mysql 比较2表不同数据

思路：

可以用union all 查出所有id group by 后 having 统计为1的即为不同数据，为2的则为相同数据

https://blog.csdn.net/luyaran/article/details/80928666

如何比较2个mysql数据库数据

sql语句：因为MySQL 没有full outer join,所以用left join union all right join来实现

select a.table_schema,

a.table_name,

a.column_name,

b.table_schema,

b.table_name,

b.column_name

from information_schema.columns a

left join information_schema.columns b on a.table_name = b.table_name and a.column_name =

b.column_name andb.table_schema = 'DBNAMe1'

where a.table_schema = 'DBNAME2' and

(b.table_name is null or

b.column_name is null)

union all

select a.table_schema,

a.table_name,

a.column_name,

b.table_schema,

b.table_name,

b.column_name

from information_schema.columns a

left join information_schema.columns b on a.table_name = b.table_name and a.column_name =

b.column_name andb.table_schema = 'DBNAME2'

where a.table_schema = 'DBNAME1' and

(b.table_name is null or

b.column_name is NULL)

---