laravel框架执行sql语句group by出错
`Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'product.id' which is not functionally dependent on columns >查看详情
在执行sql语句时,如果用了group by会提示以下错误
```
select id,product_type,count(*) from product group by product_type
> 1055 - Expression #1 of SELECT list is not in GROUP BY clause and cont >查看详情
我们知道laravel中软删除使用起来很方便
最近在使用的过程中碰到一些问题
主要是联名查询
提示名的deleted_at字段不存在
```
$list = (new Admin())->setTable('admin')->from('hl_admin as admin')->join('hl_tenant_admin as h' >查看详情
在日常的数据库查询中,我们经常用到in
比如
`select *from user where id in(1,3,2)`
有没有办法实现,按照1,3,2的顺序来排序
只需要
`select *from user where id in(1,3,2) order by field(id,1,3,2)`
在laravel中如 >查看详情