Mysql Eer Diagram To Database

by

3 Answers 3 Sorted by:

Trending sort is based off of the default sorting method — by highest score — but it boosts votes that have happened recently, helping to surface more up-to-date answers.

It falls back to sorting by highest score if no posts are trending. 8

You can try File -> Export -> Forward Engineer SQL Create Script. Here you can generate the SQL Script corresponding to your EER diagram, and execute this script in your database engine.

check out this tutorial from the MySQL website,HERE and HERE it shows how to create a connection between Workbench and the server and after that you can forward engineer any tables and such into a database. Hope its what youre looking for.:)

Database > Forward engineer… is a wizard who will guide you to the creation of the database you have modeled.

Thanks for contributing an answer to Stack Overflow!

  • Please be sure to answer the question. Provide details and share your research!
  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

    • To learn more, see our tips on writing great answers. Draft saved Draft discarded

    From the Model Editor, click Add Diagram to create a new EER diagram. When you add a diagram, a new tab appears below the toolbar. Use this tab to navigate to the newly created EER diagram. For more information about working with EER diagrams in MySQL Workbench, see Section 9.1.2, “EER Diagram Editor”.

    Enhanced Entity-Relationship (EER) diagrams are an essential part of the modeling interface in MySQL Workbench. EER diagrams provide a visual representation of the relationships among the tables in your model. Revisions made with the Model Editor are shown in the associated diagram. Similarly, the changes you make within a diagram register seamlessly in the Model Editor. MySQL Workbench applies standard concepts and symbols to show table relationships, as indicated in the following figure. To get started, review the diagram editors color key and vertical toolbar.

    This tool is for creating and editing EER diagrams for a model. To edit an existing database, either reverse engineer the database to create a model, or synchronize your model to a database. For additional information, see Section 9.4.2.2, “Reverse Engineering a Live Database” and Section 9.5, “Schema Synchronization and Comparison”.

    Enhanced Entity-Relationship (EER) diagrams are created by double-clicking Add Diagram in the Model Editor. You may create any number of EER diagrams just as you may create any number of physical schemas (databases). Each EER diagram opens in a tab below the toolbar. A specific EER diagram is selected by clicking its tab.

    FAQ

    How do I add a table from EER diagram to MySQL Workbench?

    Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the EER Diagram tab is selected, then right-click the table icon on the vertical toolbar. The table icon is the rectangular tabular icon. Clicking the mouse on this icon changes the mouse pointer to a table pointer.

    How do I open an EER diagram in MySQL Workbench?

    4 Answers
    1. Go to “Database” Menu option.
    2. Select the “Reverse Engineer” option.
    3. A wizard will be open and it will generate the ER Diagram for you.

    How do I create a database schema diagram in MySQL?

    Enhanced Entity-Relationship (EER) diagrams are an essential part of the modeling interface in MySQL Workbench. EER diagrams provide a visual representation of the relationships among the tables in your model. Revisions made with the Model Editor are shown in the associated diagram.