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
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;