在 MySQL 命令行可以执行并得到结果,但是用 Laravel 的 ORM 和 DB 就会报错
$sql = "select DATE_FORMAT(created_at,'%Y-%m-%d') as time, count(user_id) as sum, `created_at` from `we_chat_users` where unix_timestamp(created_at) > 1573488000 AND unix_timestamp(created_at) < 1574092800 group by TO_DAYS(created_at)";
无论用模型整合这条SQL,还是DB::select,都是报
Syntax error or access violation: 1055 'created_at' isn't in GROUP BY
错误
但是放入mysql执行又没有问题。
想知道是哪个地方出现了问题?或者说其实mysql执行中其实已经报了警告错误。只是没有终止,而在laravel中终止了?
推荐文章: