mysql常用命令

1、and、or运算符

• 查询id大于3并且del等于1的数据

select * from user where id>3 and del=1

• 查询id大于3或者del等于1的数据

select * from user where id>3 or del=1

2、排序order by

• 升序查询

select * from user order by id asc

• 降序查询

select * from user order by id desc

3、统计count(*)

• 查询user表中del=1的总条数

select count(*) from user where del=1

• 设置别名

select count(*) as total from user where del=1

4、分页

• 从索引为i开始查询，查询n条

select * from user limit i, n

• 实现分页

select * from user limit (i-1) * n, n