SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2002
    Location
    see above
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    using a foreign key in MySQL

    can anyone point me twards a tutorial that describes how to link child tables with the master table for MySQL, like how can i keep a userID linked to child tables for my project. I am trying to figure out how to establish referential integrity for MySQL, unless it only exists for MS Access. Thanks!

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Foreign key support is not availible on the default myISAM table in MySQL. I think INNODB supports FKs and referrential integrity.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •