zy1lu的博客

转载 解决this is incompatible with sql_mode=only_full_group_by

数据库迁移后，系统原有的sql报错： of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yj. id' which is not functionally dependent on columns in GROUP BY clause;this is incompatible with sql_mode=only_full_group_by，在网上很快找到解决办法，Mysql版本不一样导致一些配置也不一样.