增

1.直接增加一条/多条记录

insert into

2.从别的表中查出来添加

insert into select from

3.替换添加

replace into

删

delete

truncate

改

update

//注意同一张表上子查询不支持，要再select一次

查

distinct

where

//and or between like = != is null is not null

order by

group by

//having

limit

join

union