mysql57无法select * from 表 group by 字段解决办法

mysql57在select * from 表 group by 字段时报错，Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

而mysql55可以select * from 表 group by 字段并不报错，因为mysql57里
通过show variables like 'sql_mode’可以看到里面有only_full_group_by

解决办法：
分别执行

set session sql_mode= 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

和

set @@global.sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

注意先执行session的修改，再执行global的修改！！！