当前位置：Gxlcms > 数据库问题 > mysql-ERROR 1140 (42000)错误解决办法

mysql-ERROR 1140 (42000)错误解决办法

时间：2021-07-01 10:21:17 帮助过：73人阅读

student.stu_name,max(score.number) from student inner join score on student.stu_id = score.student_id inner join course on score.course_id = course.cou_id inner join teacher on course.teacher_id = teacher.tea_id where teacher.tea_name ="杨艳";

报错：

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
contains nonaggregated column ‘oldboy.student.stu_name‘ which is not functionally dependent
on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决办法：

退出mysql

vim /etc/my.ini

在[mysqld]项下添加如下代码：

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

：wq保存退出

service mysqld restart　　重启mysqld服务

问题解决！

mysql-ERROR 1140 (42000)错误解决办法

标签：group 重启 number user 报错 mysqld each date color

mysql-ERROR 1140 (42000)错误解决办法

人气教程排行