mysql 1243,MySQL＃1243提供给EXECUTE的未知预准备语句处理程序（stmt）

I am following this tutorial on my installed version of MySQL, but it's throwing me an error:

SET @sql = NULL;

SELECT

GROUP_CONCAT(DISTINCT

CONCAT(

'MAX(IF(property_name = ''',

property_name,

''', value, NULL)) AS ',

property_name

)

) INTO @sql

FROM

properties;

SET @sql = CONCAT('SELECT item_id, ', @sql, ' FROM properties GROUP BY item_id');

PREPARE stmt FROM @sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

I am pasting it on SQL editor in phpMyAdmin.

I followed the suggestion. No errors shown but here's the result:

SELECT item_id

,MAX(IF(property_name = 'color', value, NULL)) AS color

,MAX(IF(property_name = 'size', value, NULL)) AS size

,MAX(IF(property_name = 'weight', value, NULL)) AS weight

FROM properties GROUP BY item_id

解决方案

If you have access to a MySQL command-line, I think you'll find your SQL code is fine (as long as @sql doesn't equal NULL) and the issue is with phpMyAdmin. Another idea is to wrap the code in a stored procedure and then CALL the procedure.