– 查询两张表的字段数
SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA=‘数据库名’ AND TABLE_NAME=‘表a’;
SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA=‘数据库名’ AND TABLE_NAME=‘表b’;
– 查询两张表不同的字段
SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA=‘数据库名’ AND TABLE_NAME=‘表a’ AND COLUMN_NAME not IN (SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA=‘数据库名’ AND TABLE_NAME=‘表b’);
navicat查询两张表的字段数量,比较表之间不同的字段
最新推荐文章于 2024-02-01 09:58:41 发布