Visual Database Design with MySQL Workbench
Wall Script
Follow Me:
Thursday, January 08, 2009

Visual Database Design with MySQL Workbench

Few days back I received one request about Mysql WorkBench Usage. So in this post I want to explain with screen shots to create a visual database design, follow these steps.

I prepared this tutorial to improve your Database design Skills in Visual style.

Download Mysql Workbench

For example if we want to project like Twitter web site updating user profile, our database will have these entities:

1 - Users( User_name, password, email, some registration data....)

2 - Updates( Updates/Messages added by the Users)

Step 1 -> Add EER Diagram


Step 2 -> Place a New Table


Ok now... edit the table just right click.


You have to add Column and fix the Data types.


Set the table Primary Key in Column details


Same way you have to create Update table also.

Step 3->Link the both table with Relationship tools


Link the Updates table to Users table automatically generate Foreign key column.


Finally export project SQL script.


We can export ERR Diagram image *.png formate also.

If you feel free post a Comment..

Was this article helpful?
Thanks! Your feedback helps us to improve 9lessons.info


10 comments:

  1. I like the look of the software. I will be giving it a blast!

    ReplyDelete
  2. Very useful post. I did bot try MySQL WorkBench in the past but will definitely try out.

    ReplyDelete
  3. I get this below message when i try to import the sql file to my php asmin


    SQL query:

    CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'web248-drunk'@'%' to database 'mydb'

    ReplyDelete
  4. Hi Matt,

    First you have to create database with the name of 'mydb' then try to import.

    ReplyDelete
  5. MySQL said: Documentation
    #1166 - Incorrect column name 'Update_id '


    This is now the error message i am receiving sorry to be a pain.

    ReplyDelete
  6. Good start..... but very limited....u could have explained the relation ship types in the panel.Like which one to use when.... please make a descriptive tutorial..

    ReplyDelete

Make in India