常用的sql语句

常用的sql语句:

选择：select * from table1 where 范围

插入：insert into table1(field1,field2) values(value1,value2)

删除：delete from table1 where 范围

更新：update table1 set field1=value1 where 范围

查找：select * from table1 where field1 like '%value1%' ---like的语法很精妙，查资料!

排序：select * from table1 order by field1,field2 [desc]

总数：select count as totalcount from table1

求和：select sum(field1) as sumvalue from table1

平均：select avg(field1) as avgvalue from table1

最大：select max(field1) as maxvalue from table1

最小：select min(field1) as minvalue from table1

去重使用distinct  如  (select distinct `studentNo` from result)

模糊查询：

select 字段 from 表名 where 列名 like 所需查询的条件;

select * from test where name like '张%';

select * from test where name like '%二%';

select * from test where name like '%张%' and name like '%王%';

select * from test where name like '张_';

select * from test where name like concat();