I am having a big problem creating foreign key on PHPMyAdmin. I saw many people having this problem... Never I did this before, so I tried but could not figure out... In Microsoft Access, you do it directly, but on PHPMyAdmin, its a bit complicated..
I have two tables, as follows:
User
-user_id (Primary key)
-name
-age
-country
Job
-job_id (Primary key)
-job_name
-job_place
What I want is to make user_id as foreign key in Job table.
Can you explain me how to do it with the GUI PHPMyAdmin instead of query?
How to create foreign key in PHPMyAdmin?
Started by angelali, May 14 2012 05:26 AM
4 replies to this topic
#2
ignace
-
- Moderators
-
- 5,922 posts
Now mod flavored
- LocationBelgium
#3
scootstah
-
- Gurus
-
- 2,859 posts
Advanced Member
- LocationUSA
Posted 16 May 2012 - 07:11 PM
Click a table, then click Structure, then click Relation View.
while(!$succeed = try());
#4
FoxRocks
-
- Members
-
- 45 posts
Advanced Member
Posted 15 November 2012 - 06:54 AM
see here create a foreign key in phpmyadmin
For your information, I actually DID Google it and I got this thread as result.
I guess there's gotta be a douchebag on every forum, congratulations, you win!
#5
ignace
-
- Moderators
-
- 5,922 posts
Now mod flavored
- LocationBelgium
Posted 15 November 2012 - 02:00 PM
And you are the idiot who posted in a topic that hasn't had a reply in over 6 months. We all have our defects, right?
Edited by ignace, 15 November 2012 - 02:01 PM.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
