工作中常用的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 删除带有图片的回答：DELETE FROM `qh_answer` WHERE `answer_content` like '%img%'

删除一段：DELETE FROM `qh_answer` WHERE `question_id` between 622 and 640

统计数据条数：select count(*) from ?表名 多表查询：Select u.ID,u.PassWord,u.IndustryArr,u.LevelName,u. From [pH_Team_User] as u left join [pH_Team_Base] as b on u.ParentID=b.ID Where UserName='"&UserName&"'

后续会补充的。