创建一个表包含null值
mysql> select * from incr_order;
+------+
| id |
+------+
| 3 |
| 1 |
| 5 |
| 4 |
| 9 |
| 0 |
| NULL |
+------+
7 rows in set (0.00 sec)
默认排序为null值first
mysql> select * from incr_order order by id;
+------+
| id |
+------+
| NULL |
| 0 |
| 1 |
| 3 |
| 4 |
| 5 |
| 9 |
+------+
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)