mysql中null值的排序

--表user，字段age
--mysql默认null值是最小的（比空串小），所以升序时排在最前面，倒序时排在最后面

-- 默认，升序时null排在最前面
select * from 'user' ORDER BY age ASC;
-- 默认，倒序时null排在最后面
select * from 'user' ORDER BY age DESC;


-- 升序，null（和空串）排在最后面
select * from 'user' ORDER BY age is NULL ASC;
select * from 'user' ORDER BY isnull(age) ASC;
select * from 'user' ORDER BY isnull(age) || age='' ASC,age ASC;
-- 倒序，null（和空串）排在最前面
select * from 'user' ORDER BY isnull(age) || age='' DESC,age DESC;