blocks|key|1786367|text|尝试MySQL工作台，以前的DBDesigner+4：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1786368|http://dev.mysql.com/workbench/|offset|length|1786369|这有一个“反向工程数据库”模式：|1786370|数据库->反向工程|1786371|​|1786372|📷|atomic|1786373|1786374|entityMap|0|LINK|mutability|MUTABLE|url|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f43669e6dcd6ac1fc4a96da5eb6b7a84.png|imageAlt^0|0|0|V|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@$D|14|E|15|1|16]]|A|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|18|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|19|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|O|3|K|5|6|7|1E|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|C]]|W|$5|X|T|Y|A|$Z|10|11|-4]]]]

Try MySQL Workbench, formerly DBDesigner 4:

<a href="http://dev.mysql.com/workbench/" rel="noreferrer">http://dev.mysql.com/workbench/</a>

This has a "Reverse Engineer Database" mode:

Database -> Reverse Engineer

<a href="https://i.stack.imgur.com/wcoq9.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wcoq9.png" alt="enter image description here"></a>

blocks|key|1571535|text|Workbench中的“反向工程数据库”模式只是付费版本的一部分，而不是免费版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1571536|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The "Reverse Engineer Database" mode in Workbench is only part of the paid version, not the free one.

blocks|key|1786499|text|在苹果电脑上，SQLEditor会做你想做的事情。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1786500|entityMap|0|LINK|mutability|MUTABLE|url|http://www.malcolmhardie.com/sqleditor/^0|7|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

On a Mac, <a href="http://www.malcolmhardie.com/sqleditor/" rel="noreferrer">SQLEditor</a> will do what you want.

blocks|key|1786556|text|此http://code.google.com/p/database-diagram/将对您的数据库进行反向工程。只需导出'structure+only‘，然后将SQL粘贴到工具中即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1786557|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/database-diagram/^0|1|16|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

This <a href="http://code.google.com/p/database-diagram/" rel="noreferrer">http://code.google.com/p/database-diagram/</a> will reverse engineer your database. Just do an export 'structure only' then paste the SQL into the tool.

blocks|key|1786575|text|试试SchemaBank。它们也支持反向工程。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1786576|entityMap|0|LINK|mutability|MUTABLE|url|http://schemabank.com/^0|2|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try <a href="http://schemabank.com" rel="nofollow noreferrer">SchemaBank</a>. They support reverse engineering too.

blocks|key|1571744|text|我最近开始使用https://github.com/schemaspy/schemaspy。它给我的印象是在可用性和简单性之间取得了良好的平衡。(GraphViz现在是可选的)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1571745|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/schemaspy/schemaspy^0|7|12|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I've recently started using <a href="https://github.com/schemaspy/schemaspy" rel="nofollow noreferrer">https://github.com/schemaspy/schemaspy</a> . It strikes me as having a good balance between usability and simplicity. (GraphViz now optional)

blocks|key|1571765|text|试试MySQL+Maestro。对我来说很有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1571766|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlmaestro.com/products/mysql/maestro/^0|2|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try <a href="http://www.sqlmaestro.com/products/mysql/maestro/" rel="noreferrer">MySQL Maestro</a>. 
Works great for me.

blocks|key|1786725|text|MySQL工作台的工作就像一个护身符。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1786726|我刚刚将数据库结构备份到SQL脚本中，并在MWB+5.2.37+for+Windows的“从SQL脚本创建EER模型”中使用。|1786727|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

MySQL Workbench worked like a charm.

I just backed up database structure to SQL script and used it in "Create EER Model From SQL Script" of MWB 5.2.37 for Windows.

blocks|key|1786769|text|Visual+Paradigm+for+UML+9.0|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1786770|这很棒，我曾经使用mysql工作台，但对于大型数据库(大约300多个表)不会很好地工作，但视觉范式反向数据库工作得更好|1786771|entityMap|0|LINK|mutability|MUTABLE|url|http://www.visual-paradigm.com/product/vpuml/editions/community.jsp^0|0|R|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="http://www.visual-paradigm.com/product/vpuml/editions/community.jsp" rel="nofollow">Visual Paradigm for UML 9.0</a>

It's awesome I used to work with mysql bench but for big databases (something like more than 300 tables) won't work very well but visual paradigm reverse database works so much better

blocks|key|1571885|text|phpMyAdmin拥有你想要的东西(到现在已经很多年了)：它只需要少量的配置，但也能给你带来额外的好处：http://www.phpmyadmin.net/documentation/#pmadb|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1571886|entityMap|0|LINK|mutability|MUTABLE|url|http://www.phpmyadmin.net/documentation/#pmadb^0|1H|1A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

phpMyAdmin has what you are looking for (for many years now):
It takes a small bit of configuration, but gives you additional benefits too:
<a href="http://www.phpmyadmin.net/documentation/#pmadb" rel="nofollow">http://www.phpmyadmin.net/documentation/#pmadb</a>

blocks|key|1786859|text|这是一个从MySQL+(目前在Windows上)生成关系图的工具。我在一个有400个表的数据库上使用过它。如果图表对于单个图表来说太大，则会将其分解为较小的图表。因此，您可能会得到多个图，您可以通过右键单击在它们之间导航。这一切都在下面的链接中解释。该工具是免费的(就像在免费啤酒中一样)，作者自己在咨询任务中使用它，并让其他人使用它。http://www.scmlite.com/Quick%2520overview|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1786860|entityMap|0|LINK|mutability|MUTABLE|url|http://www.scmlite.com/Quick%2520overview^0|4O|13|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Here is a tool that generates relational diagrams from MySQL (on Windows at the moment).
I have used it on a database with 400 tables.
If the diagram is too big for a single diagram, it gets broken down into smaller ones. So you will probably end up with multiple diagrams and you can navigate between them by right clicking. It is all explained in the link below. The tool is free (as in free beer), the author uses it himself on consulting assignments, and lets other people use it.
<a href="http://www.scmlite.com/Quick%20overview" rel="nofollow">http://www.scmlite.com/Quick%20overview</a>

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a MySQL database? Preferably it would allow me to edit the diagram afterward since none of the foreign keys are set...

Here is what I am picturing diagram-wise (please excuse the horrible data design, I didn't design it. Let's focus on the diagram concept and not on the actual data it represents for this example ;) ):

<img src="https://i.stack.imgur.com/lxvlR.jpg" alt="diagram">
<a href="https://i.stack.imgur.com/ZnN2O.png" rel="noreferrer">see full size diagram</a>

Auto Generate Database Diagram MySQL

SQL数据库

数据库

Windows

MySQL

我厌倦了在每个项目开始时打开Dia并创建一个数据库图表。有没有工具可以让我选择特定的表，然后基于MySQL数据库为我创建一个数据库图？因为没有设置任何外键，所以它最好允许我在之后编辑图表。这是我的图表(请原谅可怕的数据设计，它不是我设计的。让我们关注图的概念，而不是它在这个示例中表示的实际数据;) )：​

问自动生成数据库关系图MySQL
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问自动生成数据库关系图MySQLEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问自动生成数据库关系图MySQL
EN