Mysql表数据查找操作

1、简单查询

select * from user;

2、NULL查询

select * from user where hobby is NULL and age is not NULL;

3、in查询

select * from user where age in('22','23','24');

4、between and查询

select * from user where age between 21 and 55;

5、or查询

select * from user where age=22 or age=23

6、order by 查询

select * from user order by age asc; 升序
select * from user order by age desc; 降序

7、

Mysql表数据查找操作

原文：https://www.cnblogs.com/feiqiangsheng/p/11441740.html