Generating DB Schema in 10 seconds with MySQL Workbench

Quick tip - how to generate a pretty database schema view from existing database.

- - - - -
Support the channel by checking out my products:

- - - - -
Other places to follow:

[OscarGarcia-bermejo]

thank you so much, I got lost in between steps in class and had no idea how to do this, you made it really fast and simple, take my like good sir

[AnilAnvesh]

That's a really useful tip to generate an ER diagram to view the relational schema of the database. Thank you ❤️

[MrGobalize]

Thanks a lot! Exactly what I was looking for, nice and quick solution to visualize the relationships in an existing DB!

[thriftynick]

I use MySQL Workbench and did not know about this. I just did it on a large demo project I'm working on. I manually built the schema first like you said, but it didn't match up exactly to what's in the actual DB. Now I can see the ERD exactly as it is using this. Great tip, thanks!

[turbokev]

This is an oldie but a goody. Didn't know you could do this with workbench!! Range the bell for that one! Just to clarify, I use similar function with other admin tools but sometimes I work in environment where workbench is only tool available and I am not most familiar with it, I have thrown my hands up before without even really checking. This knowledge will come in handy.

[bethsalvatore]

This worked great! Saved me so much time!

[Shriukan]

Thank you, quick and simple, to the point.

[nadyaamandaputrilaniaz]

thank you for the tutorial, i'm so happy and proud of you

[Jhon-hyxk]

Very good. First time that I tryed, it had a conection bug, the foreign key conection didn't appears, but I was doing something like this:
"id_editora int references editora(id) "
Then I changed it to:
"id_editora int,
foreign key (id_editora) references editora(id)"
Thus it's working very well

[NachoDLF]

Hi. I was wondering why your varchar columns had 191 characters. Is it related to indexing? I thought 255 was the best lenght, was I wrong? Thanks!

[darkghostable]

Thanks Exactly what I was looking for.

[sharakpl]

Is there a way to reverse engineer database like that from VSCode or PHPStorm?

[unknwnpilt]

Thanks a lot for the tip. But I tried to do the same on my database, and the diagram generated doesnt inclued the primary keys, or the relations between my tables, is that normal?

[johnrobertson]

Thanks, this showed that MySQL Workbench can create the links between the various database sections. The question I have is HOW? I have a large database that I attempted to reverse engineer using Workbench, and while it got all the DB boxes, it had no interconnects between DB boxes with the same ID fields. What might I be doing wrong? Anyway, a helpful video showing that the problem is at my end - my not understanding how the process should work...

[pedroAlves-fwrs]

Que cara bom, graças a deus pai .
from Brasil.

[etrgovina]

i upload script to my server using admin quick panel and i get Failed to load resource: the server responded with a status of 404 () . when i try to go login page