#1055 - Expression of SELECT lis

2017-12-06  本文已影响39人  汗青fullstack

解决方法:

进入终端后执行
mysql -u root -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

参考:

#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

上一篇 下一篇

猜你喜欢

热点阅读