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 WorkbenchFor 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..
nice post
I like the look of the software. I will be giving it a blast!
Very useful post. I did bot try MySQL WorkBench in the past but will definitely try out.
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'
Hi Matt,
First you have to create database with the name of 'mydb' then try to import.
MySQL said: Documentation
#1166 - Incorrect column name 'Update_id '
This is now the error message i am receiving sorry to be a pain.
nice share..!!