尝试一下

select distinct nu.name as Name,
                m1.status as '1',
                m2.status as '2',
                m3.status as '3',
                m4.status as '4',
                m5.status as '5',
                m6.status as '6'
           from test nu
left outer join test m1 on m1.date = '2012-01-01' and m1.name = nu.name
left outer join test m2 on m2.date = '2012-01-02' and m2.name = nu.name
left outer join test m3 on m3.date = '2012-01-03' and m3.name = nu.name
left outer join test m4 on m4.date = '2012-01-04' and m4.name = nu.name
left outer join test m5 on m5.date = '2012-01-05' and m5.name = nu.name
left outer join test m6 on m6.date = '2012-01-06' and m6.name = nu.name;