MySQL错误-this is incompatible with sql_mode=only_full_group_by完美解决方案

发表于 本文字数： 483 阅读时长 ≈ 1 分钟

1.错误

1
2
3
4
Expression #1 of SELECT list is not in GROUP BY clause and contains
nonaggregated column ‘数据库名.表名.字段名’ which is not functionally dependent
on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by

2. 查看sql_mode的语句

1
select @@GLOBAL.sql_mode;

3. 解决

1
2
set SQL_MODE = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
SET @@global.sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';