mysql sql_mode

自己装了一个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=""

然后就解决了该问题。