CODEWITHSUNDEEP
mysqlsqlrelational-databaseentity-relationshipmysql-workbench
user962206
user962206

Reputation: 16117

How to Join tables in MySql workbench?

How do I Join tables with mySql workbench visually? without using any SQL script or typing it into the query menu? I am new when it comes to using this MySql workbench, but I tried looking at their documentation and I haven't found any, any help??

Upvotes: 3

Views: 25617

Answers (2)

Sheila
Sheila

Reputation: 1

To join tables without using any SQL script or typing it into the query menu:

1) Use the EER diagram: on the menu bar ==> FILE ==> select NEW MODEL from the dropdown, then ==> click on the "Model" tab use dropdown to "Add Diagram", that will open the grid screen where you can simply click on the GUI's on the left side of the grid to create tables, join tables... you'll need to save your model for future use, if needed.

Upvotes: 0

Nonym
Nonym

Reputation: 6299

Please try these links:

http://net.tutsplus.com/tutorials/databases/visual-database-creation-with-mysql-workbench/

http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench

They give some good screenshot-oriented tutorials (especially since this is for using the graphical user interface to create your database and its objects)

Upvotes: 1

Related Questions