INSERT
-
[SQL] 기본적이지만 잘 안 외워지는 쿼리문DB/MariaDB 2020. 11. 3. 14:28
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..