mysql两个表比较差异

SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    CHARACTER_MAXIMUM_LENGTH, 
    IS_NULLABLE, 
    COLUMN_DEFAULT 
FROM 
    information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name' 
    AND (TABLE_NAME = 'table1' OR TABLE_NAME = 'table2')
ORDER BY 
    TABLE_NAME, ORDINAL_POSITION;

SELECT 
    COALESCE(t1.column_name, t2.column_name) AS column_name, 
    t1.value AS value_table1, 
    t2.value AS value_table2 
FROM 
    table1 t1 
FULL OUTER JOIN 
    table2 t2 
ON 
    t1.id = t2.id 
WHERE 
    t1.value IS NULL OR t2.value IS NULL;

SELECT 
    TABLE_NAME, 
    INDEX_NAME, 
    SEQ_IN_INDEX, 
    COLUMN_NAME, 
    COLLATION, 
    CARDINALITY, 
    SUB_PART, 
    PACKED, 
    NULLABLE, 
    INDEX_TYPE, 
    COMMENT 
FROM 
    information_schema.STATISTICS 
WHERE 
    TABLE_SCHEMA = 'your_database_name' 
    AND (TABLE_NAME = 'table1' OR TABLE_NAME = 'table2')
ORDER BY 
    TABLE_NAME, INDEX_NAME, SEQ_IN_INDEX;