且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

#1055-SELECT列表的表达式不在GROUP BY子句中,并且包含未聚合的列,这与sql_mode = only_full_group_by不兼容

更新时间:2021-11-09 22:10:36

我为此进行了艰苦的工作,我对其进行了测试,并且在lamp服务器mysql版本5.12上可以正常工作

I had a struggle getting this to work i've tested it and it's working on lamp server mysql version 5.12

因此,成功的步骤:

  1. sudo vim /etc/mysql/conf.d/mysql.cnf
  2. 滚动到文件底部,复制并粘贴

  1. sudo vim /etc/mysql/conf.d/mysql.cnf
  2. Scroll to the bottom of file Copy and paste

[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

[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

到文件底部

  1. 保存并退出输入模式
  2. sudo service mysql restart重新启动MySQL.
  1. save and exit input mode
  2. sudo service mysql restart to restart MySQL.

完成!