How to Generate an ERD in MySQL Workbench

Ғылым және технология

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
MySQL Workbench has a cool feature that lets you generate an ERD (Entity Relationship Diagram) from your database.
This can be helpful for understanding the structure of your database.
You can select which databases and tables to include, rearrange the diagram, and see how they are related.
You can also create a diagram with tables and columns and generate the SQL to create the tables.
Learn how to do all of that in this video
Timestamps:
00:00 What we can do in MySQL Workbench
00:27 Generate a diagram from a database
02:27 View the diagram
04:32 Toolbar features
05:45 Create a new blank diagram
07:39 Generate SQL from an ERD for one table
09:02 Generate SQL for the whole diagram

Пікірлер: 27

  • @burner918
    @burner918 Жыл бұрын

    Love your tutorials. Thank you so much for these.

  • @DatabaseStar

    @DatabaseStar

    Жыл бұрын

    Glad you like them!

  • @parwamuhsin5033
    @parwamuhsin50333 күн бұрын

    That was the thing that I wanted. Thank u so muchhhhhhhhhhh

  • @DatabaseStar

    @DatabaseStar

    5 сағат бұрын

    Glad it was helpful!

  • @ofekthepro1239
    @ofekthepro12393 ай бұрын

    good video!!

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Thanks!

  • @smtxtv
    @smtxtv3 ай бұрын

    No kangaroos in Austria. Great tutorial. Thx !

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Thanks!

  • @ofekthepro1239
    @ofekthepro12393 ай бұрын

    in more professional tone. It seems the document provided is a Data Structure Diagram (DSD), which typically offers a visual depiction of the data structure and its relationships. However, an Entity-Relationship Diagram (ERD) would be more appropriate for detailing relationships, including many-to-many relationships. In an ERD, relationships are explicitly defined, and many-to-many relationships are typically represented using associative tables to establish the connection between entities

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Thanks for the information!

  • @EDGE94
    @EDGE94 Жыл бұрын

    When I load an existing db, only the selected tables are plottet but not the relationships (lines). It's not possible that in an existing db no foreign keys have been defined, is it?

  • @DatabaseStar

    @DatabaseStar

    Жыл бұрын

    Yeah it is possible that a database has no foreign keys. It’s not mandatory, but it’s recommended. So if there are no foreign keys then there would not be any lines on the diagram.

  • @emericpetitgenet3512
    @emericpetitgenet35124 ай бұрын

    Hi, what is the mysql server version used for this great tutorial ?

  • @DatabaseStar

    @DatabaseStar

    4 ай бұрын

    It's 8.0.28

  • @emericpetitgenet3512

    @emericpetitgenet3512

    4 ай бұрын

    Don't have the left toolbar in the EER tab, any idea ? @@DatabaseStar

  • @gerryren3337
    @gerryren3337 Жыл бұрын

    Hi! Got a question here, every time when I click the reverse engineer the software crash, why this happen?

  • @DatabaseStar

    @DatabaseStar

    11 ай бұрын

    Oh I'm not sure, you may have to Google it or get in touch with the support team for MySQL Workbench

  • @user-pb2hp4em3q

    @user-pb2hp4em3q

    5 ай бұрын

    maybe you clicked it too hard?

  • @Dr_Speedy

    @Dr_Speedy

    4 ай бұрын

    Same thing happens with me. Tried multiple different versions, different machines, db in docker/bare metal.... It used to work before my schema got big, so thinking it has something to do with that. Did you ever figure out a solution?

  • @ZakariaSaid45
    @ZakariaSaid453 ай бұрын

    I have just removed some objects to exclude them in my Er diagram but none of them disappear in the final results 😢

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Oh that’s strange, I’m not sure why that would happen.

  • @IamCaptainDeadpo0l
    @IamCaptainDeadpo0l3 ай бұрын

    Are you from Austria. Well then. G'day, mate! Let's put another shrimp on the barbie!

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Australia actually, but yeah those are things we’re known to say!

  • @IamCaptainDeadpo0l

    @IamCaptainDeadpo0l

    3 ай бұрын

    ​@@DatabaseStar You are too nice to jerks like me my good sir or should i say Dag. i hope you have a great day and a great morning as well, in which you had a nice smashed avo in a toast for brekkie with your top notch Sheila in your budgie smugglers and if you are having brekkie in your budgie smugglers with your top notch Sheila you are a root rat in my book. you are making us Dags feel jealous.

  • @IamCaptainDeadpo0l
    @IamCaptainDeadpo0l3 ай бұрын

    sup first mate , 2nd mate, 3rd mate, 4mate, 5mate, 6mate, 7mate, 8mate, 9mate..... i am tired matey.

  • @DatabaseStar

    @DatabaseStar

    3 ай бұрын

    Nice one 😅

  • @IamCaptainDeadpo0l

    @IamCaptainDeadpo0l

    3 ай бұрын

    @@DatabaseStar You are too nice to jerks like me my good sir or should i say Dag. i hope you have a great day and a great morning as well, in which you had a nice smashed avo in a toast for brekkie with your top notch Sheila in your budgie smugglers and if you are having brekkie in your budgie smugglers with your top notch Sheila you are a root rat in my book. you are making us Dags feel jealous.

Келесі