mysql中将多行数据合并成一行数据
标签：字段名 pre inf ima val model 记录 font The
mysql中将多行数据合并成一行数据
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