当前位置：Gxlcms >
数据库问题 >
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
时间：2021-07-01 10:21:17
帮助过：3人阅读
mysqld]
sql_mode=‘NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES‘
如果没有my.cnf,有my.ini.txt也行。
参考：
https://www.cnblogs.com/skymyyang/p/7551646.html
https://blog.csdn.net/huihuikuaipao_/article/details/84106480
MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause
标签：com tables res pip logs group by mode ipa 方案
