วิธี execute query string in mysql

1. เป็นการสร้าง Procedure
-- ----------------------------
-- Procedure structure for genCol
-- ----------------------------
DROP PROCEDURE IF EXISTS `genCol`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `genCol`(IN `str` TEXT CHARSET utf8)
    NO SQL
BEGIN
    SET @s = CONCAT('CREATE TEMPORARY TABLE tempTB as ',str,';' );
  PREPARE stmt FROM @s;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;

  SHOW COLUMNS FROM tempTB;

  DROP TEMPORARY TABLE tempTB;
END
;;
DELIMITER ;

2. วิธีเรียก Procedure CALL genCol('SELECT * FROM table_name');