更新时间: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
因此,成功的步骤:
sudo vim /etc/mysql/conf.d/mysql.cnf
滚动到文件底部,复制并粘贴
sudo vim /etc/mysql/conf.d/mysql.cnf
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
到文件底部
sudo service mysql restart
重新启动MySQL.sudo service mysql restart
to restart MySQL.完成!
错误 1055 (42000):SELECT 列表的表达式 #1 不在 GROUP BY 子句中......这与 sql_mode=only_full_group_by 不兼容
#1055-SELECT列表的表达式不在GROUP BY子句中,并且包含未聚合的列,这与sql_mode = only_full_group_by不兼容
SELECT 列表不在 GROUP BY 子句中并且包含非聚合列 .... 与 sql_mode=only_full_group_by 不兼容
SELECT 列表不在 GROUP BY 子句中并且包含非聚合列......与 sql_mode=only_full_group_by 不兼容
#1055 - SELECT 列表的表达式不在 GROUP BY 子句中,并且包含与 sql_mode=only_full_group_by 不兼容的非聚合列