flawless69
Programmer
Does anyone know how to add Foreign Keys after the tables have been created? --Derek
"Fear not the storm for this is where we grow strong."
"Fear not the storm for this is where we grow strong."
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding Foreign Keys
- Thread starter flawless69
- Start date
- Status
sleipnir214
Programmer
Take a look here:
______________________________________________________________________
TANSTAAFL!
______________________________________________________________________
TANSTAAFL!
- Thread starter
- #3
flawless69
Programmer
Does this work? I've seen this page but it mentions something further down about it not actually doing anything. --Derek
"Fear not the storm for this is where we grow strong."
"Fear not the storm for this is where we grow strong."
Foreign keys aren't really supported (hence neither is referential integrity!!), in any release under 3.23.43b ( You need InnoDB table types). If you want to use these you need mysql3.23-max installation.
I'm attempting to get this working on my win98 pc but have major problems with the .cnf file where you need to enanle InnoDB.
If anyone can help in this area it'd be great!!!
I'm attempting to get this working on my win98 pc but have major problems with the .cnf file where you need to enanle InnoDB.
If anyone can help in this area it'd be great!!!
- Status