group_concat合并行,例如把year字段的值打印在一行,逗号分隔。
select * from sales
select *, (select group_concat(year separator ',') from sales where year>'2012') as years_temp from sales;
group_concat合并行,例如把year字段的值打印在一行,逗号分隔。
select * from sales
select *, (select group_concat(year separator ',') from sales where year>'2012') as years_temp from sales;