Question

mysql select的数据合并，多行合并成一行，列拆分

原来的格式
id type name
1 0 10
1 1 11
2 0 20
2 1 21
我想要的格式：
id name0 name1
1 10 11
2 20 21

有没有给力伙伴，感谢了

Answer 1

select *
from
(select
name as name0
from
user
where
type = '0') as A,
(select
name as name1
from
user
where
type = '1') as B
group by name0

user 为表名。