coder9 Posted July 24, 2008 Share Posted July 24, 2008 Is it possible to assign foreign key using PHPMyAdmin? If yes, how? Thank you very much in advance. Quote Link to comment Share on other sites More sharing options...
akitchin Posted July 24, 2008 Share Posted July 24, 2008 last i checked, there's no specific button for it - you may need to run the query manually to set a foreign key. keep in mind i might be wrong, i've never used PMA on a table with the InnoDB engine running (or any other engine that properly supports foreign keys). Quote Link to comment Share on other sites More sharing options...
damianjames Posted July 24, 2008 Share Posted July 24, 2008 Can you set a foreign key with PHPMyAdmin using the relation view? (View a table in DB -> click "Relation View" under the fields listing -> click the select box in the fields in the "Links To" table). Just guessing here, and the answer is as much for me as the OP. Quote Link to comment Share on other sites More sharing options...
akitchin Posted July 24, 2008 Share Posted July 24, 2008 hmm, that's a good question - i was actually previously unaware that a "relation view" existed. if someone else can swoop in and answer this, it would be awesome. Quote Link to comment 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.