Inno Db

[YoLoL]

Is there a way to define a foreign key using myPHPAdmin GUI?

[OJB]

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.

[getitdone]

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.

[OJB]

Is your table structure definitely InnoDB?

 

You need indexes and/or primary keys set on the table before the relation view option will appear.