【mysql】 GROUP BY col ORDER BY NULL

最新推荐文章于 2024-07-30 03:44:11 发布

Yqq__00

最新推荐文章于 2024-07-30 03:44:11 发布

阅读量2.1k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/Yqq__00/article/details/52423126

版权

数据库专栏收录该内容

47 篇文章 0 订阅

订阅专栏

在使用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)