phpmyadmin- need help in foreign key creation
hi..every1. i need a help in creating foreign keys in phpmyadmin. here.. i have used phpmyadmin for creating database. in this i have created 2 tables- employee and department. employee table has deptno as 1 of its attributes. this deptno is in department table as primary key..i have to define deptno of employee table as foreign key that references to deptno in department table. now, there is an option in phpmyadmin for including primary key constraints but there is no such option for includinf foreign key constraint..
plzzzz help...😔
plzzzz help...😔
Replies
-
Manish GoyalThere is a option buddy
First click on child table ,(I am assuming department is a child table here and employee is a parent table here)
Now click on structure
Now You will see options like Print view ,relation view at bottom
Click on relation view
Rest I hope you can do
PS😛lease if in future you have any query ,better create a new thread for this ,instead of asking through private messages, so that others can also take benefits .
Ok 😀 -
patil.ashu01hey...thanx buddy....thanx a lot.. i gt it!!! thanx:smile:
You are reading an archived discussion.
Related Posts
Hi,
I want to do my final year project in flash with actionscript programming ,plz post some project topics on this domain
hi.............i want to take an array of integers as input using command line arguments. how can i do it? and please tell me what are environment variables? are they related...
I have a doubt. c does not support function overloading. but if anyway we want to use it, how can we do it?
CEans,
It’s been just over a month since aj_onduty aka Ajit joined CrazyEngineers. Within such a short period of time he has impressed all with his presence all over CE....
what is an environment variable? is it related with classpath?