Welcome Guest, Not a member yet? Register   Sign In
Help with Foreign Keys
#3

[eluser]GSV Sleeper Service[/eluser]
Quote:You can only use a foreign key in an InnoDB table (at least in MySQL)
not true, you can only use foreign key constraints in an InnoDB table. There's no actual way of knowing that a column is a foreign key in a MyISAM, but you can still set them up as such, it just won't inform you that you are about to destroy the referential integrity of your DB when you try to do something silly (like deleting a comment that is still referenced in your posts table)


Messages In This Thread
Help with Foreign Keys - by El Forum - 10-28-2008, 12:39 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 03:11 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 05:07 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 05:11 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 05:16 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 05:18 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 09:06 AM
Help with Foreign Keys - by El Forum - 10-28-2008, 10:58 AM



Theme © iAndrew 2016 - Forum software by © MyBB