Laravel SQL 查询失败, SQL 语句本身没有问题。
我写了一个这样的接口:
访问该接口报错42000:
"message": "SQLSTATE[42000]: Syntax error or access violation: 1055 'fb.fb_res.spend' isn't in GROUP BY (SQL: select `user`, SUM(spend) as spend, SUM(purchase_value) as purchase_value, SUM(shipping_fee) as shipping_fee, (spend/purchase_value) as roas from `fb_res` group by `user`)",
"code": "42000",
"status_code": 500,
提示SQL语法错误,而在数据库中执行该语句是正确的:
请问为什么?
推荐文章: