DEV Community

Cover image for SQL Review - How to create an ERD in MySQL
Jo
Jo

Posted on • Edited on

1 1

SQL Review - How to create an ERD in 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.

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay