对比数据库表结构

对比同一个服务器上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