Leif160519的blog Leif160519的blog

——————

目录
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
/  

MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题


问题 ：

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方案：

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

image.png

“The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.” – Tom Cargill

标　　题：MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
作　　者：Leif160519
出　　处：https://github.icu/articles/2019/08/30/1567128792295.html
关于博主：坐标六朝古都南京，服务器运维工程师+桌面运维工程师，如有问题探讨可以直接下方留言。
声援博主：如果您觉得文章对您有帮助，可以评论、订阅、收藏。您的鼓励是博主的最大动力！