MYSQL中竖表转横表

表结构

select goods_id,
sum( case field_code when ‘watch_count’ then field_value else 0 end ) watch_count,
sum( case field_code when ‘favorite_count’ then field_value else 0 end ) favorite_count,
sum( case field_code when ‘comment_count’ then field_value else 0 end ) comment_count,
sum( case field_code when ‘praise_count’ then field_value else 0 end ) praise_count
from tbl_good group by goods_id