在Laravel中使用groupBy('字段')时报错,错误信息为:SQLSTATE[42000] Syntax error or access violation 1055 '字段' isn't in GROUP BY.txt,但是在navicat中执行相同的sql语句确不会出现报错提示,因此确定为Laravel框架中mysql设置的问题,经过检查发现是Laravel中启用了mysql严格模式,关闭该项设置即可。、
将下图中的
|
1
|
'strict'=>true
|
改为
|
1
|
'strict' => false
|
即可
![Laravel报SQLSTATE[42000] Syntax error or access violation 1055 'xxx' isn't in GROUP BY.txt错误的解决办法 Laravel报SQLSTATE[42000] Syntax error or access violation 1055 'xxx' isn't in GROUP BY.txt错误的解决办法](https://www.zhujige.net/wp-content/uploads/2020/07/20200722_5f187a03b589d.png)
主机阁






