用于从MySQL查询生成数据库模式图的工具

时间:2021-01-28 12:58:54

May I know is there any tool for generating database schema diagram from MySQL query dump from phpmyadmin? Thanks!

我可以知道是否有任何工具可以从phpmyadmin的MySQL查询转储生成数据库架构图?谢谢!

4 个解决方案

#1


0  

"From MySQL query" is vague - do you mean from a SHOW CREATE TABLE query?

“来自MySQL查询”是模糊的 - 你的意思是从SHOW CREATE TABLE查询?

Regardless, with the right access, MySQL Workbench will reverse engineer the schema and create a diagram for you.

无论如何,通过正确的访问,MySQL Workbench将对架构进行反向工程并为您创建一个图表。

#2


0  

try MySQL Workbench, follow below link http://www.mysql.com/products/workbench/

试试MySQL Workbench,请点击以下链接http://www.mysql.com/products/workbench/

#3


0  

Try the MySQL workbench. It is buggy at times but will do the job. It is a official oracle product as well.

试试MySQL工作台。它有时是错误的,但会完成这项工作。它也是官方的oracle产品。

#4


0  

You can generate schemas from existing tables using MySQL Administrator. Personally I like Navicat, but you'd need to buy a license.

您可以使用MySQL Administrator从现有表生成模式。我个人喜欢Navicat,但你需要购买许可证。

#1


0  

"From MySQL query" is vague - do you mean from a SHOW CREATE TABLE query?

“来自MySQL查询”是模糊的 - 你的意思是从SHOW CREATE TABLE查询?

Regardless, with the right access, MySQL Workbench will reverse engineer the schema and create a diagram for you.

无论如何,通过正确的访问,MySQL Workbench将对架构进行反向工程并为您创建一个图表。

#2


0  

try MySQL Workbench, follow below link http://www.mysql.com/products/workbench/

试试MySQL Workbench,请点击以下链接http://www.mysql.com/products/workbench/

#3


0  

Try the MySQL workbench. It is buggy at times but will do the job. It is a official oracle product as well.

试试MySQL工作台。它有时是错误的,但会完成这项工作。它也是官方的oracle产品。

#4


0  

You can generate schemas from existing tables using MySQL Administrator. Personally I like Navicat, but you'd need to buy a license.

您可以使用MySQL Administrator从现有表生成模式。我个人喜欢Navicat,但你需要购买许可证。