SQL - 기초 개념, 문법(assorted)

 

 

DDL

CREATE

CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;

CREATE TABLE table_name(column_name datatype, ... );

 

ALTER

ALTER TABLE table_name RENAME new_table_name

ALTER TABLE table_name ADD COLUMN acolumn_name double;

ALTER TABLE table_name MODIFY COLUMN column_name data_type;

ALTER TABLE table_name CHANGE COLUMN column_name new_column_name new_data_type;

ALTER TABLE table_name DROP COLUMN column_name;

 

DROP

DROP TABLE table_name

 

DML

SELECT

SELECT column1, column2, ... FROM table_name;

SELECT * FROM table_name;

SELECT column1, column2, ... FROM table_name WHERE condition;

 

UPDATE

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

 

DELETE

DELETE FROM table_name WHERE condition;

 

OREDER BY

SELECT col1, col2, ... FROM table_name ORDER BY col1, col2, ... ASC|DESC;

SELECT col FROM db_name WHERE condition ORDER BY col ASC|DESC;