mysql的null值排序

最新推荐文章于 2024-07-25 13:51:31 发布

RT_0114

最新推荐文章于 2024-07-25 13:51:31 发布

阅读量255

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/Smy_0114/article/details/104994687

版权

MySQL 专栏收录该内容

53 篇文章 1 订阅

订阅专栏

mysql默认null参与排序时候是最小值

mysql> select * from user order by age asc;
+----+------+------+----------+
| id | name | age  | class_id |
+----+------+------+----------+
|  2 | rt   | NULL |     NULL |
|  1 | smy  |    0 |        0 |
+----+------+------+----------+
2 rows in set (0.00 sec)

把null放在后面处理

mysql> select * from user order by if(isnull(age),1,0), age asc;
+----+------+------+----------+
| id | name | age  | class_id |
+----+------+------+----------+
|  1 | smy  |    0 |        0 |
|  2 | rt   | NULL |     NULL |
+----+------+------+----------+
2 rows in set (0.00 sec)