angelali Posted May 14, 2012 Share Posted May 14, 2012 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? Link to comment https://forums.phpfreaks.com/topic/262500-how-to-create-foreign-key-in-phpmyadmin/ Share on other sites More sharing options...
ignace Posted May 14, 2012 Share Posted May 14, 2012 see here create a foreign key in phpmyadmin Link to comment https://forums.phpfreaks.com/topic/262500-how-to-create-foreign-key-in-phpmyadmin/#findComment-1345379 Share on other sites More sharing options...
scootstah Posted May 17, 2012 Share Posted May 17, 2012 Click a table, then click Structure, then click Relation View. Link to comment https://forums.phpfreaks.com/topic/262500-how-to-create-foreign-key-in-phpmyadmin/#findComment-1346167 Share on other sites More sharing options...
FoxRocks Posted November 15, 2012 Share Posted November 15, 2012 On 5/14/2012 at 5:11 PM, ignace said: 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! Link to comment https://forums.phpfreaks.com/topic/262500-how-to-create-foreign-key-in-phpmyadmin/#findComment-1392572 Share on other sites More sharing options...
ignace Posted November 15, 2012 Share Posted November 15, 2012 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? Link to comment https://forums.phpfreaks.com/topic/262500-how-to-create-foreign-key-in-phpmyadmin/#findComment-1392722 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.