mysql5.7执行sql语句报错：In aggregated
2018-08-08 本文已影响34人
史庆雨
报错
mysql5.7执行sql语句报错：In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'yunva_changke.u.user_id'; this is incompatible with sql_mode=only_full_group_by
如图
解决方案：
1.编辑/etc/my.cnf文件 如图 2.重启mysql服务
