对比同一个服务器上bbc库和ebc库的表结构,查询结果为两个库中互不存在的字段:
select a.TABLE_SCHEMA,a.TABLE_NAME,a.COLUMN_NAME,a.DATA_TYPE,a.COLUMN_DEFAULT
from information_schema.`COLUMNS` a
where a.TABLE_SCHEMA='bbc' and a.COLUMN_NAME NOT IN(SELECT b.COLUMN_NAME from information_schema.`COLUMNS` b where b.TABLE_SCHEMA='ebc' and a.TABLE_SCHEMA='bbc'
and a.TABLE_NAME=b.TABLE_NAME );
select a.TABLE_SCHEMA,a.TABLE_NAME,a.COLUMN_NAME,a.DATA_TYPE,a.COLUMN_DEFAULT
from information_schema.`COLUMNS` a
where a.TABLE_SCHEMA='ebc' and a.COLUMN_NAME NOT IN(SELECT b.COLUMN_NAME from information_schema.`COLUMNS` b where b.TABLE_SCHEMA='bbc' and a.TABLE_SCHEMA='ebc'
and a.TABLE_NAME=b.TABLE_NAME );
可参考原文:http://www.cnblogs.com/chenmh/p/5447205.html