mysql5.7包错getDefContactByUserId exception: Expression #4 of SELECT list is not in GROUP...in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by MySQL

mysql5.7包错getDefContactByUserId exception: Expression #4 of SELECT list is not in GROUP…in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

原因 之前的MySQL5.6升级到MySQL5.7后,执行查询语句的时候，报错，如下： getDefContactByUserId exception: Expression #4 of SELECT...
06月07日 66 viewsmysql5.7包错getDefContactByUserId exception: Expression #4 of SELECT list is not in GROUP…in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by已关闭评论 收藏
阅读全文