MySQL Forums
Forum List  »  Newbie

Re: Help to fiy my databse
Posted by: Peter Brawley
Date: September 25, 2020 10:21AM

"Cannot add or update a child row ... a foreign key constraint fails" means exactly what it says ... the failing command tried to insert a key value which a foreign key constraint prohibits. So what value of `create_by` is the cmd trying to insert, and what is the result of ...

select count(*) from users where users.id = <that value>;

?

Options: ReplyQuote


Subject
Written By
Posted
September 25, 2020 07:09AM
Re: Help to fiy my databse
September 25, 2020 10:21AM
September 27, 2020 06:33AM


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.