你可以试试下面-

SET @sql = NULL;
        SELECT
          GROUP_CONCAT(DISTINCT
            CONCAT(
              'MAX(IF(type = ''',
              type,
              ''', total, NULL)) AS ',
              type
            )
          ) INTO @sql
        FROM order_products_sizes;

        SET @sql = CONCAT('SELECT name, ', @sql, ' 
                           FROM tablename group by name');

        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;

尝试：

select name, if(type='type1', sum(type),0) as type1, 
if(type='type2', sum(type),0) as type2 .................... from table_name group by name