1.约束
constraint constraint_name check(codition)
constraint constraint_name unique(column_name)
constraint constraint_name foreign key (column_name)
reference table_name(column_name)
on delete cascase
2.修改表
alter table <表名>
add column_name | modify column_name | drop column_name
3.drop table <表名>
4.rename oldname to newname
5.insert
insert into table_or_view_name
values()
可以使用insert ...select
6.修改数据
update <table_or_view_name>
set column_name={expression | default | null}
where <search_condition>
7.delete from tablename
where search_condition
truncate table tablename
commit