MySQL Forums
Forum List  »  InnoDB

Re: Possible constraint creation
Posted by: Peter Brawley
Date: November 23, 2015 01:00PM

To see what's causing the error, we need the results of Show Create Table for each table, including the departments table to which, presumably, dept_id refers.

An underlying problem---and a worse problem---is the attempt to resolve missing subdept keys with a famous hack known as "the zeroth key". It's completely unsound. We need the table defs to find a sound solution.

Options: ReplyQuote


Subject
Views
Written By
Posted
1478
November 20, 2015 11:56AM
688
November 20, 2015 12:20PM
797
November 23, 2015 06:20AM
Re: Possible constraint creation
756
November 23, 2015 01:00PM
743
November 23, 2015 07:01AM


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.