column 列

insert into tab_name (field1,field2,field3...) values (value1,value2,value3...)

select * from tab_name

insert [into] tab_name set field1=value1,field2=value2;

修改表记录：update tab_name set field1=value1 where field=value; where语句不加是针对所有记录

delete from tab_name where id=2 or id=3;

delete from tab_name；删除记录

truncate table tab_name; 销毁表，再创建一个空表