0

MySQL 怎样对比两个数据库表结构差异？

MySQL
mona created at6 years ago view count: 2467
report
回复
0
daisy #

先导出表结构然后在用diff工具对比。

mysqldump --skip-comments --skip-extended-insert -u root -p db1 >file1.sql
mysqldump --skip-comments --skip-extended-insert -u root -p db2 >file2.sql
diff file1.sql file2.sql
vimdiff  file1.sql file2.sql
6 years ago 回复

Recommend

相关搜索关键词

Recent search keywords