MySQL 查询在 phpMyAdmin 中运行，而不是在 Laravel 中运行

Question

我有以下查询:

SELECT a.*, Count(b.status) as counttotal 
FROM holidays a LEFT JOIN attendances b 
on a.month_id=b.month_id 
GROUP BY a.month_id

此查询在 phpMyAdmin 中成功执行。

当我尝试通过 php artisan tinker 运行相同的查询时，出现以下错误:

Illuminate\Database\QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 'school_blog.a.month' isn't in GROUP BY (SQL: SELECT a.*, Count(b.status) as counttotal FROM holidays a LEFT JOIN attendances b on a.month_id=b.month_id GROUP BY a.month_id)'

我该如何解决这个问题？

Answer 1

转到您的 config/database.php 并将以下“true”更改为“false”，使其如下所示

'mysql' => [

    'strict' => false,

]