Menu
I just want to ask about my problem. Right now I have an existing database and tables. And I want to get the structures of every table. I just need to get their column name for comparison for other tables.
But How can I include this in an EER diagram? What I did is I copied all the tables column in a paper and I manually inputted the details to the MySQL workbench EER tool. I have a lots of tables. So it is so difficult for me to input one by one all of the tables. Is there an easy way? Can you provide me any links how to do that? Ok that's all. Thanks.
991
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.
To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram editor. The EER Diagram canvas is where object modeling takes place.
To import a file, open Workbench and click on + next to the MySQL connections option. Fill in the fields with the connection information. Once connected to the database go to Data Import/Restore. Choose the option Import from Self-Contained File and select the file.
If you want to generate an EER Diagram of existing MySQL database you can use the Reverse Engineer feature of MySQL workbench.
Database -> Reverse Engineer
79
Two ways to start reverse engineering process in MySQL workbench (actual version June 2016):
a) go to the main site and on the right side of of the header "Models" click on the ">" sign and select "Create EER Model from Database"
b) key combination: Ctrl + R
26
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
