Question

sql这语法错误应该怎么解决 ECSHOP

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.sales_volume, g.comments_number, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, RAND() AS rnd FROM `kjt`.`ipro_goods` AS g LEFT JOIN `kjt`.`ipro_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.goods_id IN ('') ORDER BY g.sort_order, g.last_update DESC ) [2] => Array ( [error] => Unknown column 'g.sales_volume' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

Answer 1

您好：

Unknown column 'g.sales_volume' in 'field list

已经说的很清楚了。在表内不存在的列。

查看sales_volume列是否存在。

如果存在的话，请检查数据类型，和是否有异常数据。

只看语句是没有语法错误的，必须看表结构和数据。