skaterdav85 12 Posted April 2, 2009 Report 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 Quote Link to post Share on other sites
Stefano 0 Posted April 2, 2009 Report 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. Quote Link to post Share on other sites
justsomeguy 1,135 Posted April 2, 2009 Report 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. Quote Link to post Share on other sites
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.