- cd /etc/mysql/mysql.conf.d/(没有找到就去 /etc/my.cnf )
- sudo vim mysqld.cnf
- 在[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"
- 重启mysql:/etc/init.d/mysql restart (Debian / Ubuntu Linux)
/etc/init.d/mysqld restart (RedHat Linux (Fedora Core/Cent OS))
mysql5.7报错1055, “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
最新推荐文章于 2023-09-06 09:58:11 发布