我需要从 mysql 数据库转储生成 er 图。我尝试了很多工具,例如 MySQL WorkBench,它们仅生成表,但不生成它们之间的连接。我需要这样的东西http://www.cacti.net/downloads/docs/sql/database_schema.pdf http://www.cacti.net/downloads/docs/sql/database_schema.pdf(最后一页)。哪个软件可以做到?谢谢。
SchemaCrawler for MySQL http://schemacrawler.sourceforge.net/ is a free tool that generates diagrams. SchemaCrawler can infer relationships between tables, based on commonly used naming conventions, and display these with dotted lines. Here is an example diagram http://schemacrawler.sourceforge.net/images/diagram.png: