解析:在mysql 工具 搜索或者插入数据时报下面错误:
error 1055 (42000): expression #1 of select list is not in group by clause and contains nonaggregated column 'database_tl.emp.id' which is not fu...
mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
出现这个错误已导致在开发中mybatis的sql也运行不了
原因:
看一下group by的语法:
select 选取分组中的列+聚合函数 from 表名称 ...