进入mysql命令行模式：
mysql>执行命令
set @@global.sql_mode ='NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
声明:
本文采用
BY-NC-SA
协议进行授权，如无注明均为原创，转载请注明转自
winfred的博客
本文地址: mysql错误：[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
本文地址: mysql错误：[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
