.Net

MySQL WorkBench - A great tool for your databases (Part - 2)

This is a continuation to an earlier entry by the name “MySQL WorkBench - A great tool for your databases“.

In the previous article we just talked the features and what can be done with MySQL WorkBench. In this I added a dummy table with few columns, indexes and I showed how you can create a ER (Entity Relationship) Diagram. Attached are the screenshots that were taken during each step. These screenshots talk for themselves.

MySQL WorkBench - Default

MySQL WorkBench - Naming a database

MySQL WorkBench - Adding a new table

MySQL WorkBench - Adding Columns

MySQL WorkBench - Adding Indexes

MySQL WorkBench - Adding ER Diagram

MySQL WorkBench - A great tool for your databases (Part - 2)

MySQL WorkBench - A great tool for your databases

If you use MySQL and design databases for MySQL, then this is the tool for you. This is a free download that you can download from MySQL’s website and use it. With this tool you can design your database, tables, relationships, triggers etc.. And you have a great GUI for specifying various tbale level options. You can save all these to a file, and open it and continue your work. When you think you are done. You can export to .sql file and run the .sql file against your database which creates the required tables, indexes, relations etc.. When you export you can export either as Create statements / Alter statements. Now for some greate screenshots of the tool. Can be downloaded from here.

Below are some screenshots:

MySQL WorkBench

MySQL WorkBench

MySQL WorkBench

MySQL WorkBench

Related:
MySQL WorkBench - A great tool for your databases (Part - 2)

MySQL WorkBench - A great tool for your databases