报错:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dev_xmjt.m.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
报错以及解决办法: mysql 查询语句中select后面用了聚合函数比如COUNT(),则其他被查询的字段都应该是聚合函数,否则就会报错