nazmy Posted February 12, 2008 Share Posted February 12, 2008 Does anyone know how to create a foreign key using phpmyadmin? thank you in advance... Link to comment https://forums.phpfreaks.com/topic/90592-foreign-key-using-phpmyadmin/ Share on other sites More sharing options...
svivian Posted February 12, 2008 Share Posted February 12, 2008 I'm not sure if it is possible through the GUI, but you should be able to do it with a SQL query. Check http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html for information and the syntax. I do know that your database tables need to use InnoDB storage rather than MyISAM (I think it says at the bottom of the table when you look at the structure). Link to comment https://forums.phpfreaks.com/topic/90592-foreign-key-using-phpmyadmin/#findComment-465218 Share on other sites More sharing options...
nazmy Posted February 13, 2008 Author Share Posted February 13, 2008 Thanx... Link to comment https://forums.phpfreaks.com/topic/90592-foreign-key-using-phpmyadmin/#findComment-465553 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.