mysql 两个库差异对比

-- 创建一个存储过程来对比两个数据库的表结构
DELIMITER //

CREATE PROCEDURE CompareTableStructures(IN db1 VARCHAR(255), IN db2 VARCHAR(255))
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE tableName VARCHAR(255);
    DECLARE sql1 TEXT;
    DECLARE sql2 TEXT;
    DECLARE cur1 CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_schema = db1;
    DECLARE cur2 CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_schema = db2;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur1;
    OPEN cur2;

    read_loop: LOOP
        FETCH cur1 INTO tableName;
        FETCH cur2 INTO tableName;

        IF done THEN
            LEAVE read_loop;
        END IF;

        SET @sql1 = CONCAT('SELECT * FROM ', db1, '.', tableName, ' LIMIT 1');
        SET @sql2 = CONCAT('SELECT * FROM ', db2, '.', tableName, ' LIMIT 1');

        PREPARE stmt1 FROM @sql1;
        PREPARE stmt2 FROM @sql2;

        EXECUTE stmt1;
        EXECUTE stmt2;

        DEALLOCATE PREPARE stmt1;
        DEALLOCATE PREPARE stmt2;

        -- 这里可以添加更多的逻辑来对比两个查询的结果集结构
    END LOOP;

    CLOSE cur1;
    CLOSE cur2;
END //

DELIMITER ;