MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Add referential integrity
Posted by: Barry Galbraith
Date: August 01, 2015 01:37AM

>Can I update DETAIL to enforce this? Foreign-Key?

See the refman for ALTER TABLE Add CONSTRAINT FOREIGN KEY ...

http://dev.mysql.com/doc/refman/5.5/en/alter-table.html

Both tables need to be InnoDB engine or the Foreign Key won't be enforced.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Add referential integrity
Alan Honeyman
August 01, 2015 12:26AM
Re: Add referential integrity
Barry Galbraith
August 01, 2015 01:37AM
Re: Add referential integrity
Alan Honeyman
August 01, 2015 03:36AM
Re: Add referential integrity
Alan Honeyman
August 01, 2015 08:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.