报错信息:
In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'qkt.u.user_id'; this is incompatible with sql_mode=only_full_group_by
执行sql:
SELECT u.`user_id`,COUNT(1)goldNum FROM tb_user u WHERE u.`recommend_id`=11 AND partner_level=1;
解决:
此报错是因为在不使用order by的聚合查询中,以上标红处不能同时出现.
sql换种写法,用聚合函数时只用聚合函数