【mysql】 GROUP BY col ORDER BY NULL

         在使用group by col的时候,mysql 会自动order by col ,在只需要分组不需要排序的情况下,可用使用可以使用GROUP BY col ORDER BY NULL提升执行效率,仅仅对col列分组,而不排序。


mysql> select * from testy;
+--------+---------+---------------------+
| rec_id | message | created             |
+--------+---------+---------------------+
|    404 | 3       | 2016-09-03 14:00:18 |
|    405 | 4       | 2016-09-03 14:00:18 |
|    406 | 3       | 2016-09-03 14:03:52 |
|    407 | 1       | 2016-09-03 14:03:52 |
+--------+---------+---------------------+
4 rows in set (0.00 sec)

mysql> select * from testy group by message;
+--------+---------+---------------------+
| rec_id | message | created             |
+--------+---------+---------------------+
|    407 | 1       | 2016-09-03 14:03:52 |
|    404 | 3       | 2016-09-03 14:00:18 |
|    405 | 4       | 2016-09-03 14:00:18 |
+--------+---------+---------------------+
3 rows in set (0.00 sec)


mysql> select * from testy group by message order by null;
+--------+---------+---------------------+
| rec_id | message | created             |
+--------+---------+---------------------+
|    404 | 3       | 2016-09-03 14:00:18 |
|    405 | 4       | 2016-09-03 14:00:18 |
|    407 | 1       | 2016-09-03 14:03:52 |
+--------+---------+---------------------+
3 rows in set (0.00 sec)





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值