mysql中将多行数据合并成一行数据
时间：2021-07-01 10:21:17
帮助过：16人阅读
order_id ,GROUP_CONCAT( (
case when azfxj
>0 and type
= ‘0‘ then CONCAT(
‘就(‘, area_2,
‘m²‘ ,
‘ ‘, count_2,
‘套)‘)
else ‘‘ end ) SEPARATOR
‘,‘) modelName
FROM typg_house_order_choose
where order_id
=‘0500c6a25f2249c08289970305eacc11‘
GROUP BY order_id
mysql中将多行数据合并成一行数据
标签：字段名 pre inf ima val model 记录 font The
