create_dynamic_table.sql

DELIMITER $$
DROP PROCEDURE IF EXISTS p1 $$
CREATE PROCEDURE p1 (name CHAR(250))
BEGIN
    SET @tablename = CONCAT('table_', name);
    SET @d = CONCAT('DROP TABLE IF EXISTS ', @tablename);
    PREPARE dm FROM @d;
    EXECUTE dm;
    SET @c = CONCAT('CREATE TABLE ', @tablename, '(`id` INT PRIMARY KEY)');
    PREPARE cm FROM @c;
    EXECUTE cm;
END $$

DELIMITER ;