分类：数据库 发布时间：2017-05-30 10:39:44 阅读： 作者：郑祥景
选择：select * from table where 范围
插入：insert into table(field1,field2) values(value1,value2)
删除：delete from table where 范围
更新：update table set field1=value1 where 范围
查找：select * from table where field1 like ’%value1%’
排序：select * from table order by field1,field2 [desc]
总数：select count as totalcount from table
求和：select sum(field1) as sumvalue from table
平均：select avg(field1) as avgvalue from table
最大：select max(field1) as maxvalue from table
最小：select min(field1) as minvalue from table
编辑：郑祥景
城市：
邮箱:656861622@qq.com
