0
daisy
6 years ago 回复了 MySQL 怎样对比两个数据库表结构差异？

先导出表结构然后在用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

Broadcast


JoyK
Better personal homepage
reddit style
GitHub Flavored Markdown syntax
Adaptive layout