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? Quote 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 Quote 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. Quote 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 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! Quote 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 (edited) 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 November 15, 2012 by ignace Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.