select goods_id ,concat (",",GROUP_CONCAT(optiona_id),",") from `lux_product_goods_property_val` group by goods_id
MySQL group by后的结果将每组某VARCHAR字段字符串连接起来
最新推荐文章于 2024-07-26 03:51:44 发布
select goods_id ,concat (",",GROUP_CONCAT(optiona_id),",") from `lux_product_goods_property_val` group by goods_id