mysql group_concat

group_concat合并行，例如把year字段的值打印在一行，逗号分隔。

select * from sales

select  *, (select group_concat(year separator ',') from sales where year>'2012') as years_temp from sales;