skaterdav85 Posted April 2, 2009 Share Posted April 2, 2009 Hi,can someone describe to me how you create a 1 to 1 relationship for 2 tables in phpmyadmin or know of a place where i can find a tutorial? I couldnt find one.Thanks Link to comment Share on other sites More sharing options...
Stefano Posted April 2, 2009 Share Posted April 2, 2009 Hi,can someone describe to me how you create a 1 to 1 relationship for 2 tables in phpmyadmin or know of a place where i can find a tutorial? I couldnt find one.ThanksSincerilly I don't whether phpmyadmin give you such a possibility to do that interactively, like access do. I usually manage differently:1) Just create a signle table, why not?2) Manage with triggers through by SQL rather then phpmyadminIf you think triggers can solve I'll replay and give you prices tips. Link to comment Share on other sites More sharing options...
justsomeguy Posted April 2, 2009 Share Posted April 2, 2009 If you want to set up a foreign key relationship, the tables must be using InnoDB, MyISAM does not support foreign keys. I'm not sure if phpMyAdmin gives an interface to set up foreign keys, you may need to use SQL commands. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.