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