SET sql_mode=DEFAULT;

DROP PROCEDURE IF EXISTS p1;

DROP TABLE IF EXISTS t1,t2;

DELIMITER $$

CREATE PROCEDURE p1()

BEGIN

  DECLARE a INT DEFAULT 10;

  DECLARE cur1 CURSOR FOR SELECT a;

  BEGIN

    DECLARE rec1 ROW TYPE OF cur1;

    CREATE TABLE t2 AS SELECT rec1.a;

    SHOW CREATE TABLE t2;

    DROP TABLE t2;

  END;

END;

$$

DELIMITER ;

CALL p1();

+-------+-----------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                  |

+-------+-----------------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `rec1.a` bigint(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+-----------------------------------------------------------------------------------------------+