1.增 insert

insert into 表 (列名,列名...) values (值,值,值...)
insert into 表 (列名,列名...) values (值,值,值...),(值,值,值...)
insert into 表 (列名,列名...) select (列名,列名...) from 表

2.删 delete

delete from 表
delete from 表 where id＝1 and name＝'123'

3.改 update

update 表 set name ＝ 'a' where id>1

4.查 select

select * from 表
select * from 表 where id > 1
select nid,name,gender as gg from 表 where id > 1