laravel使用groupby，sql报错 QueryException In Connection.php line 671 : SQLSTATE[42S22]: Column not ...

最新推荐文章于 2022-12-06 18:05:17 发布

Koukiki

最新推荐文章于 2022-12-06 18:05:17 发布

阅读量499

点赞数

本文链接：https://blog.csdn.net/Koukiki/article/details/116242052

版权

问题：出现的原因是 groupby后接的变量是一个字符串String类型，$selectRow变量中有.号，groupby会认为这是拼接两个字符串的符号，导致拼接成sql查询时，以.为分隔符出现类似这样的情况

select delivery.customers_name,delivery.project_name,SUM(product_cube) as product_cube from delivery inner join mixing_plant on mixing_plant.id = delivery.mixing_plant_id inner join ipc on ipc.ipc_id = delivery.ipc_id where (ipc_type = 0) and 1=1 group by delivery.customers_name,delivery.project_name

解决办法：直接拿数组中的值

print_r($fields);

Array ( [0] => mixing_plant.short_name [1] => delivery.customers_name [2] => delivery.project_name [3] => delivery.print_concrete [4] => delivery.slump_level [5] => delivery.construction_place [6] => delivery.pouring_method [7] => delivery.ipc_id )

在这里插入图片描述