« Mysql View DEFINER and SQL Security
List foreign keys in mysql »

Create foreign key using Phpmyadmin

The innodb storage engine supports foreign keys in Mysql.
To create foreign keys in phpmyadmin :

1. Convert both tables into innodb.
2. View the structure of the table which will have a foreign key. Make the referencing field an INDEX.
3. Now come back to structure view and click Relation view. In the Relation view page the field (which was made an INDEX) can be made a foreign key referencing to some other field in another table.

Popularity: 11% [?]

2 Responses to “Create foreign key using Phpmyadmin”

  1. thanks for the info. Just exactly what I need. :)

  2. plz tell me how to create forign key in phpmyadmin through diagram………

Leave a Reply