通过isnull函数排序,该函数判断是否为null值,是返回1否返回0
mysql> select * from incr_order order by isnull(id)-1,id
-> ;
+------+
| id |
+------+
| 0 |
| 1 |
| 3 |
| 4 |
| 5 |
| 9 |
| NULL |
+------+
7 rows in set (0.00 sec)
通过isnull函数排序,该函数判断是否为null值,是返回1否返回0
mysql> select * from incr_order order by isnull(id)-1,id
-> ;
+------+
| id |
+------+
| 0 |
| 1 |
| 3 |
| 4 |
| 5 |
| 9 |
| NULL |
+------+
7 rows in set (0.00 sec)