一.说明 几个简单的基本的sql语句,不常写,就容易忘记。
1.查询 select * from table1 where 范围
2.插入 insert into table1 (field1,field2)values(value1,value2)
3.删除 delete from table1 where 范围
4.更新 update table1 set field1=value1 ,field2= value2 where 范围
5.like查询 select * from table1 where filed1 like '%value1%'
6.排序 select * from table1 order by filed1 desc [or asc]
7.总数 select count(*) as totalcount from table1
8.求和 select sum(field1) as sumvalue from table1
9.平均 select avg(field1) as avgvalue from table1
10.最大 select max(field1) as maxvalue from table1
11.最小 select min(field1) as minvalue from table1
----between and ----
eg:
select *
from table1
where salary
between 2000 and 5000
select *
from table1
where salary >=2000 and salary <=5000
----or ----
eg:
select tname,dname,sal
from teacher
where dname='计算机'
or dname='生物'
order by dname
----not in ----
eg:
select tname,dname,sal,age
from teacher
where dname
not in('计算机','生物','机械工程')
order by dname
----not ----
eg:
select tname,dname,sal,age
from teacher
where
not dname = '计算机'
order by dname
select tname,dname,sal,age
from teacher
where
not sal > 1500
order by dname
-----------<> not != --------
not 可以有其他运算符组合查询
eg:
select tname,dname,sal,age
from teacher
where
not age between 40 and 50
order by dname