查询语法 select 字段列表 from where
SELECT * FROM nn
SELECT id,name from nn
SELECT * from nn where id=3
SELECT * from nn where age<19
SELECT * from nn where age<19 and phone = 3370582
增加语法 insert(into) 表名
insert into nn values(4,‘hjhj’,‘980’,‘2009-10-2’,‘男’,‘337980’,‘0’)
insert into nn(name) values(‘ok’)
insert into nn(name,salary) values(‘ok’,3000)
修改语法 update set
update nn set age=age+1 where id=3 or id=4
update nn set age=age+10,salary=890 where id=3
删除
delete from nn where id=7
delete from nn where id in(2,5)
delete from nn where salary=3000
统计
SELECT count(id) from nn
SELECT count(*) from nn
SELECT max(age) from nn
SELECT avg(age) from nn
排序 order by
SELECT * from nn ORDER BY id desc
limit 获取指定范围的数据
select * from nn limit 5
select * from nn limit 2,4
int pageSize=10
int pageSize=1
select * from nn limit pageSize offset (pageCount-1) * pageSize
链接
SELECT * FROM student where student.cid= class.classid
inner join
SELECT * from student INNER JOIN class on student.cid=class.classid
获取左表中的所有数据 如果建立的关联字段在右表中的没有,那么右边相应字段为null
select * from student left JOIN class on student.cid=class.classid
反之
select * from student right JOIN class on student.cid=class.classid