mysql数据库表比较diff

select table_name frominformation_schema.tables where table_schema='ehsuat' and table_type='basetable';

 

先将所有表名查出来放在一个tables.txt 文件中

 

set serverinfo= mysqldiff--server1=user:password@ip:port--server2=user:password@ip:port  --changes-for=server1--difftype=sql

set server1=dabase_name01

set server2=dabase_name02

 

@echo off

 

for /f %%i in (tables.txt) doecho "%serverinfo% %server1%.%%i:%server2%.%%i" | mysqluc>>result.txt

参考:https://www.cnblogs.com/chenmh/p/5447205.html

https://blog.csdn.net/fdipzone/article/details/78884518