DROP PROCEDURE IF EXISTS p1;

DELIMITER $$

CREATE PROCEDURE p1()

BEGIN

  DECLARE a INT;

  DECLARE b FLOAT;

  CREATE OR REPLACE TABLE t1 AS SELECT a, b;

END;

$$

DELIMITER ;

CALL p1;

DESCRIBE t1;

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

| Field | Type       | Null | Key | Default | Extra |

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

| a     | bigint(11) | YES  |     | NULL    |       |

| b     | double     | YES  |     | NULL    |       |

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