alter (1) 썸네일형 리스트형 [SQL] 기본적이지만 잘 안 외워지는 쿼리문 CREATE TABLE e.g. CREATE TABLE tbl_name ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, lastname VARCHAR(20) NOT NULL, firstname VARCHAR(20) NOT NULL); ADD COLUMN ALTER TABLE tbl_name ADD [COLUMN] [IF NOT EXISTS] col_name column_definition [FIRST | AFTER col_name] CHANGE COLUMN NAME ALTER TABLE tbl_name CHANGE [COLUMN] [IF NOT EXISTS] old_col_name new_col_name column_definition MODIFY COLUMN AL.. 이전 1 다음
