[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

ALTER TABLE tbl_name MODIFY [COLUMN] [IF NOT EXISTS] col_name column_definition [FIRST | AFTER col_name]

 

INSERT

INSERT [INTO] tbl_name [(col, ...)] {VALUES | VALUE} ({expr | DEFAULT},...),(...),...

e.g. INSERT INTO person (first_name, last_name) VALUES ('John', 'Doe');

e.g. INSERT INTO tbl_name VALUES (1, "row 1"), (2, "row 2");
e.g. INSERT INTO person SET first_name = 'John', last_name = 'Doe';