社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
Mac系统使用MySQL(5.7.29)时,会出现如下错误:
复制
1 |
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 functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
在sql执行时,出现该原因:
打开终端,登陆mysql(mysql -u root -p)
输入下面的语句,修改sql_mode
复制
1 |
set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; |
5分钟学会MySQL-this is incompatible with sql_mode=only_full_group_by错误解决方案
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!