mysql数据库大消息不区分与1055错误记录

mysql数据库查询语句加入group by报错1055

查询mysql中sql_mode配置
SELECT @@SESSION.sql_mode;
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
									

修改配置为下面格式
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 ';

mysql查询不区分大小写

select * from t_sms_mode where BINARY user_name = 'ceshiA'

加入BINARY关键字