mysql修改表多个数据库

DELIMITER //

CREATE PROCEDURE modify_table_names()
BEGIN
    DECLARE db_name VARCHAR(100);
    DECLARE done INT DEFAULT FALSE;

    -- 定义游标，用于遍历所有数据库
    DECLARE cur CURSOR FOR SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA;

    -- 定义异常处理
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO db_name;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 在当前数据库中修改表名
        SET @sql = CONCAT('RENAME TABLE ', db_name, '.old_table TO ', db_name, '.new_table');
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;