[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 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
SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
解决方案：
select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
![[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL Mysql 第1张](https://img.liuyixiang.com/image/2019/4/f6ZFNv.png "[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL Mysql 第1张")
完美的解决方案是：
1 show variables like "sql_mode"; 2 3 set sql_mode=''; 4 set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
![[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL Mysql 第2张](https://img.liuyixiang.com/image/2019/4/z6F7ru.png "[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL Mysql 第2张")
更多精彩
