SQL

101 阅读1分钟

DDL(CREATE)

create table table_name 
(
 column1 data_type,
 column2 data_type,
 column3 data_type
 primary key(one or more columns)
);

DDL(DROP/TRUNCATE)

DROP TABLE table_name;
TRUNCATE TABLE table_name;

DDL(COMMENT)

single line comment
/* multi line comment */

DDL(RENAME)

alter table table_name 
rename to   new_table_name;

alter table     table_name
rename column   old_name 
to              new_name;

DML(SELECT)

select column1,
       column2,
       ...
from   table_name;  

select * from table_name;

select *
from table_name
where condition...;

DML(UPDATE)

update table_name
set column1= value1,
    column2 = value2,
where conditions;

DML(DELETE)

delete from table_name
where consitions;