mysql 5.7 1055 报错
2018-08-17 本文已影响0人
cifer_pan
vim /etc/my.cnf
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESservice mysqld restart
具体原因参照:MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause - 小铁匠、 - 博客园
vim /etc/my.cnf
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESservice mysqld restart
具体原因参照:MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause - 小铁匠、 - 博客园