YoLoL Posted April 21, 2009 Share Posted April 21, 2009 Is there a way to define a foreign key using myPHPAdmin GUI? Quote Link to comment Share on other sites More sharing options...
OJB Posted April 21, 2009 Share Posted April 21, 2009 Yes Make sure you have set up the necessary indexes on the tables to enable the foreign key Then under the structure view of your table click on: "relation view" just above where you add new fields. You can then create the required foreign keys for the table. Quote Link to comment Share on other sites More sharing options...
getitdone Posted April 22, 2009 Share Posted April 22, 2009 I don't see that in mine. I see print view and propose table structure. propose table structure does not let you do anything. I post cause I have the same question. Quote Link to comment Share on other sites More sharing options...
OJB Posted April 22, 2009 Share Posted April 22, 2009 Is your table structure definitely InnoDB? You need indexes and/or primary keys set on the table before the relation view option will appear. 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.