Posted on Mar 22, 2021 • Edited on Apr 12, 2021

SQL Review - How to create an ERD in MySQL

#sql #mysql

During my self study of SQL, I've encountered the concept of the ERD or the Entity Relationship Diagram, which seems quite interesting as it can be useful in building your database. It also seems gives you a visual representation of the tables in your database which I assume can also aid in problem solving.

In order to create an ERD in MySQL, select Database > Reverse Engineer, as demonstrated by the graphic below:

Then, select the Continue button

MySQL will now ask for your password, which will be the same password you used to create the database initially.

Next, you will be asked to select a database to work with. Select a database, then select "Continue".

Select "Execute"

Tada, there is your ERD.

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.