1、 选择
select * from table_name where 条件范围
2、插入
insert into table_name(column1,column2,...) values(value1,value2...);
3、删除
delete from table_name where 范围
4、更新
updata table_name set columnname=value1 where 条件范围
5、查找
select * frome table_name where columns like '%value%‘
6、排序
select * from table_name order by columns [desc(降序)/aesc(升序)]
7、总数
select count * as totalcount form. table_name
8、求和
select sum(field) as sumvalue from table_name
9、平均
select avg(field) as avgvalue from table_name
10、最大
select max(field) as maxvalue from table_name
11、最小
select min(field) as minvalue from table_name
