Jump to content

Table Relationships In Phpmyadmin


Recommended Posts

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
Sincerilly 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 post
Share on other sites

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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...