เขียน query ได้ แต่นำมาสร้างเป็น view ไม่ได้ค่ะ mysql T_T

CREATE TABLE `works` (
  `w_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) DEFAULT NULL,
  `w_date` date DEFAULT NULL,
  `w_detail` text,
  PRIMARY KEY (`w_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;


CREATE TABLE `persons` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_name` varchar(100) DEFAULT NULL,
  `p_position` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

SET @sql = '';
SELECT
	GROUP_CONCAT(DISTINCT
		CONCAT(
			'CASE WHEN w_date = ''',
			w_date,
			''' THEN w_detail else ''-'' END AS `',
			w_date, '`'
		)
	) INTO @sql
FROM works;

SET @sql = CONCAT('SELECT p.name, p.position, ', @sql, ' 
            from persons p
            inner join works w
              on p.id = w.id
            group by p.id');

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