Error Code: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jx_report.user_active_statistics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
使用以下命令查询:
SELECT @@sql_mode;
修改mode:
SET GLOBAL sql_mode = '';
修改好了以后需要重启sqlyog才能生效。
注意,这里只是使用命令方式修改的,并没有修改配置文件,所以下一次重新登录会失效。