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
ReplyDeleteI like the look of the software. I will be giving it a blast!
ReplyDeleteVery useful post. I did bot try MySQL WorkBench in the past but will definitely try out.
ReplyDeleteI get this below message when i try to import the sql file to my php asmin
ReplyDeleteSQL 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,
ReplyDeleteFirst you have to create database with the name of 'mydb' then try to import.
MySQL said: Documentation
ReplyDelete#1166 - Incorrect column name 'Update_id '
This is now the error message i am receiving sorry to be a pain.
nice share..!!
ReplyDeletenice shareee
ReplyDeleteGood 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..
ReplyDeletegreat post..
ReplyDelete