mysql pivot attr reverse(also now as pivot-table) as view

attr.sql

SET @sql = NULL;
SET @sourcetable = 'Table';
set @viewname = CONCAT(@sourcetable,'F');
SET @@group_concat_max_len = 10000;
SELECT GROUP_CONCAT(DISTINCT
                    CONCAT(
                        'MAX(IF(name = ''',
                        name,
                        ''', data, NULL)) AS ',
                        '''',
                        name,
                        ''''
                    )
)
INTO @sql
FROM Table
WHERE 'name' IS NOT NULL AND 'name' != '';
SET @sql = CONCAT('CREATE OR REPLACE VIEW ', @viewname, ' AS ','SELECT id,parent_id, ', @sql, ' FROM `Table` GROUP BY parent_id');
SELECT @sql;
PREPARE attr_varchar FROM @sql;
EXECUTE attr_varchar;
DEALLOCATE PREPARE attr_varchar;