首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

mysql中null值的排序有关问题分析

2013-02-24 
mysql中null值的排序问题分析如下表t_user:select * from t_user order by ageselect * from t_user orde

mysql中null值的排序问题分析
如下表t_user:
select * from t_user order by age;
select * from t_user order by age is null, age;
select * from t_user order by age is null, age;
等价于:

select * from (select name, age, (age is null) as isnull from t_user) as foo order by isnull, age;

看出来了吗?

热点排行