ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate

最新推荐文章于 2024-09-08 19:42:24 发布

冷子夜

最新推荐文章于 2024-09-08 19:42:24 发布

阅读量2.7k

点赞数

分类专栏： MySQL Linux 文章标签： Mysql Ubantu

本文链接：https://blog.csdn.net/qq_29180565/article/details/90386728

版权

Linux 同时被 2 个专栏收录

15 篇文章 0 订阅

订阅专栏

MySQL

7 篇文章 0 订阅

订阅专栏

🌳🌳🌳个人博客：Harvey的个人博客 🌲🌲🌲

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

mysql> show variables like 'sql_mode';

+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                                     |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set

博主的服务器是Ubantu的，修改/etc/mysql/mysql.conf.d文件，

在[mysqld]下面添加sql_mode

[mysqld]

user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
character-set-server=utf8
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

因为报的是sql_mode=only_full_group_by错误，就把它从sql_mode中去除掉。

保存配置文件。

/etc/init.d/mysql restart

重新启动mysql,就可以了。