블로그
-
데이터 베이스 SQL 정리하기
[CREATE TABLE 표기 형식] CREATE TABLE student name VARCHAR(15) NOT NULL, stud.no CHAR(8). spoon CHAR(9) CHECK
blog.naver.com · 2021.10.15
-
컬럼 추가 및 삭제 - 쿼리
추가 ALTER TABLE `테이블명` ADD `컬럼명` 자료형 예를 들면, (디폴트나 not null 추가 가능 -- int(11) NOT NULL DEFAULT '0', bigint (20) NOT NULL DEFAULT '0', varchar(30) NOT NULL, ) -- 컬럼추가 삭제 ALTER TABLE `테이블명` DROP `컬럼명`;
blog.naver.com · 2020.09.22
-
Charlotte's Web 1~6 리뷰
Arable put a pitcher of cream on the table. “Certainly not,” a little runty pig “This is the most terrible case of injustice I ever heard of.”...
blog.naver.com · 2020.12.24
-
생활 코딩 database2 mysql
-------- 데이터 베이스 결정 use opentutorials; 결과 Database changed ------------ primary key (중복 금지) create table topic ( id int(11) not null auto_increment, title varchar(100) not null, description text null,(null은
blog.naver.com · 2020.04.08
-
Hashtable clear() Method in Java
Syntax: Hash_table.clear() Parameters: The method does not accept any parameters. Return Value: The method does not return any value.
blog.naver.com · 2019.08.22
-
YBM 고교 영어교과서 1 요점정리 (Lesson 1. El Sistema: Changing Lives Through Music ) 부정사, 동명사, 관계대명사, 등위상관접사
(p20-L12) ④ The most tragic thing about poverty is not the lack of bread on the table, but the feeling
blog.naver.com · 2019.06.10
-
[MySQL] 쿼리
INT(1) DEFAULT '0' NOT NULL AFTER ID; --컬럼명 변경 ALTER TABLE 테이블명 CHANGE 기존컬럼명 변경한컬럼명 컬럼타입 ALTER TABLE USER CHANGE ID USR_ID VARCHAR(20) NOT NULL; --컬럼 타입 변경 ALTER TABLE 테이블명 MODIFY 컬럼명 변경할타입 --컬럼 삭제 ALTER
blog.naver.com · 2019.03.08
-
Disenchantment 5화 표현, 단어정리
Read a room (= read the table) 분위기를 읽다 : to understand the emotion and thoughts of people in the room a person who doesn't belong to a widely held religion as regarded by those who do. ex) Sisters, do not
blog.naver.com · 2019.04.14
-
Ms Sql 프로시저 변경 이력
로그용 테이블 생성 CREATE TABLE dbo.SPLOG( 일련번호 int IDENTITY(1,1) NOT NULL, 오브젝트명 varchar(100) NULL, 구분 varchar
blog.naver.com · 2018.09.06
-
American students looking
Most people use the column to roll up and place under a rocky kitchen table. American students looking for world-class dental education do not have to travel according to the Shanghai
blog.naver.com · 2018.07.29