mysql 5.6 升级到 mysql5.7

线上数据库是5.6 然而本地数据库 用的是XP环境最低是5.7 在迭代数据时出现的问题

Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'testapi_xinenhua.ob_browsing_history.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

经过大量百度查询 亲测有效的方式

找到对应MySQL文件中的my.ini文件

在[mysqld] 下加上 sql_mode=

 [mysqld]
sql_mode=

如图：

在重新重庆一下MySQL服务，问题就解决了