Aug
25
2009

Create foreign key using Phpmyadmin

An article by Binary Tides

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

1. Convert both tables into innodb, if they are not already.

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.

Phpmyadmin Relation View Link

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.

Phpmyadmin Foreign Key

That should do it.

Popularity: 26% [?]

11 Comments + Add Comment

slevon December 2, 2011 at 4:51 pm

Hi,
this is great!
But I experienced that all my relations will be lost when I export and import the db.
Do you know a way to keep this relations alive after a backup/restore process?

Best wishes,
slevon

Reply
- Binary Tides December 2, 2011 at 7:17 pm
  
  If you use mysqldump then foreign keys are kept intact in the table definition.
  If you restore over existing tables (which dont have foreign key relation) then you need to drop tables so that fresh tables are created again with the correct foreign key relations.
  
  Reply
Serikjan November 27, 2011 at 1:55 pm

Thank you very much. So much help

Reply
Rakesh Tembhurne November 25, 2011 at 11:24 am

That’s what I was looking for. Now I can get associated models work together in CakePHP. Thanks!

Reply
Dhanya November 20, 2011 at 4:29 pm

Thank You very much…..
It ws really very useful….

Reply
venkat October 13, 2011 at 11:36 am

tnx dear

Reply
Thilini May 26, 2011 at 4:22 pm

Thanks. Clear and to the point.

Reply
mano March 14, 2011 at 3:58 am

hi..i wanna know how to create foreign key within phpmyadmin
can anyone plz help……

Reply
Viral September 17, 2010 at 1:43 pm

Thanks buddy

Reply
Gautam September 22, 2009 at 6:49 am

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

Reply
xxx September 19, 2009 at 11:53 am

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

Reply