删表:drop table 表名
插入:insert into table1(field1,field2) values(value1,value2)
模糊查询:select * from table1 where field1 like ’%value1%’
添加:insert into 表名 values (value1,value2……)
删除:delete from 表名 where 范围
修改:update 表名 set field1=value1 where 范围
查询:select * from 表名 where 范围
排序:select * from 表名 order by field1,field2[desc]
总数:select count as total count from 表名
求和:select sum(field1) as sumvalue from 表名
平均:select avg(field1) as avgvalue from 表名
最大:select max(field1) as maxvalue from 表名
最小:select min(field1) as minvalue from 表名