自己装了一个mysql 5.7
执行一段简单的sql
select * from user_bankinfo GROUP BY user_id
竟然:
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cgsuat.user_bankinfo.bankInfo_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
刚开始并不懂这个是什么意思:百度慢慢了解是mysql 的sql_mode做的鬼,
于是修改了my-default.ini文件的
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES ————————》sql_mode=""
然后就解决了该问题。