mysql存储过程删除多个表

DELIMITER //

CREATE PROCEDURE DeleteMultipleTables()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE tableName VARCHAR(255);
    DECLARE tablesToDelete CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_schema = 'your_database_name' AND table_name LIKE 'prefix_%';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN tablesToDelete;

    read_loop: LOOP
        FETCH tablesToDelete INTO tableName;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @drop_sql = CONCAT('DROP TABLE ', tableName);
        PREPARE stmt FROM @drop_sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE tablesToDelete;
END //

DELIMITER ;