Circular foreign key dependency in Sakila?
Hi!
I'm trying to create a new store with a new manager in Sakila, but I've run into a circular problem.
To create a new staff member I need to assign it to a store that I haven't created yet.
To create a new store I need to assign it a manager that I haven't created yet.
Is this supposed to be possible to do without setting foreign_key_checks to 0 or alter the tables to allow null?
No big deal, I can work around it ofcourse, but is there a correct way?
Subject
Written By
Posted
Circular foreign key dependency in Sakila?
May 04, 2018 12:55PM
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.