PDA

Click to See Complete Forum and Search --> : Foreign Key


abhilashdas
Jun 26th, 2006, 12:00 AM
Can anybody tell me how to set foreign key using phpmyadmin??

john tindell
Jun 26th, 2006, 08:43 AM
Just enter the same information for the foriegn key as what is in the table it is relating to. Not sure what you are really asking for as AFAIK their isnt a way to create relations, like in access, with PHPMyAdmin

visualAd
Jun 26th, 2006, 10:59 AM
Mysql 4 (not sure about 5) does not have foreign key constraints. You need to enforce the integrity in the application.

mendhak
Jun 26th, 2006, 03:22 PM
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

abhilashdas
Jun 27th, 2006, 12:23 AM
Thanks for the reply