Home > Database > Mysql Tutorial > 如何用workbench导出mysql数据库关系图

如何用workbench导出mysql数据库关系图

PHPz
Release: 2019-01-30 16:10:08
Original
1953 people have browsed it

1. 打开mysql workbench,选择首页中间"Data Modeling"下方的第二栏"Create EER Model From Existing Database";

2. 在"Stored Connection"里选择"Manage Stored Connections…";

3. 在Manage DB Connections里选择“New”新建连接,并在左侧输入框里填好想连接的数据库信息;

4. 测试数据库连接,连接成功后返回到2的界面,在"Stored Connection"里选择刚才新建好的连接;

5. 依次单击2次"next",在"select schemata to reverse engineer"选择要到处的数据库名称,继续单击"next";

6. 导出的数据库关系图里所有表格是重合在一起的,需要手动将表格拖动到相应的位置。


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template