运行报错:
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test.dept_emp.emp_no’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法:
在Navicat下执行下面语句,重新打开即可成功。
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
原因
MySQL5.7.5及以上默认启用了ONLY_FULL_GROUP_BY
SQL模式,也就是依赖检测功能。MYSQL将拒绝选择列表,这时HAVING条件或ORDER BY查询出的数据会被认为是未命名的非集合列。