Laravel 5.4 中带有内连接和计数的 MySql 查询

Question

我的 sql 查询在 phpmyadmin 中显示正确，但是当我在 laravel 5.4 项目中使用它时，它显示错误

SQLSTATE[42000]: Syntax error or access violation: 1055 'project_management.addprojects.id' isn't in GROUP BY (SQL: SELECT DISTINCT addprojects.id,addprojects.emp_id,sum(tasks.task_weight),tasks.flag from addprojects JOIN tasks ON tasks.proj_id = addprojects.id GROUP BY tasks.proj_id )

DB::select(" SELECT DISTINCT addprojects.proj_name,addprojects.id,
   addprojects.emp_id,sum(tasks.task_weight),tasks.flag from addprojects 
  JOIN tasks ON tasks.proj_id = addprojects.id GROUP BY tasks.proj_id ");

Answer 1

这是因为 Laravel 使用严格模式。您可以从 config/database.php 禁用它，您将在 mysql 数组配置中看到

'strict' => true,

将其设置为false，您的查询将起作用

从 here 了解有关严格 SQL 模式的更多信息