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... Quote Link to comment 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). Quote Link to comment Share on other sites More sharing options...
nazmy Posted February 13, 2008 Author Share Posted February 13, 2008 Thanx... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.