SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: using a foreign key in MySQL
-
Jun 17, 2002, 06:33 #1
- 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!
-
Jun 17, 2002, 06:52 #2
- 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.
Matt - Sybase DBA / PHP fanatic
Sybase/MySQL/Oracle | I don't like MySQL
Download Sybase | DBForums.com - for all your RDBMS talk
Bookmarks