Use MySQL Workbench to draw e-r diagrams

MySQL Workbench is a er/ database modeling tool designed for MySQL . You can use MySQL Workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations. This article describes using MySQL Workbench to draw e-r diagrams.

method / Step

1. Find the software in the Start menu, click Open

2. After you start the software, you do not need to connect to the database (many people connect directly to the database so there is no place for designing ER models)

3. Click "+" to enter the model design interface

4. Double-click Add Diagram to enter the following design interface

5. Click on the toolbar table and click in the design area and a table1 will appear and double-click it

6. Finally execute the "File" and "Export" button, select Forward Engineer SQL CREATE Script (ctrl+shift+g). This allows you to export the model as a SQL script file. Now execute the SQL file and it's OK .

Use MySQL Workbench to draw e-r diagrams