MySQL Error 1452 – ER_NO_REFERENCED_ROW_2

MySQL Error Message

Cannot add or update a child row: a foreign key
constraint fails (%s)

Reason for the Error

InnoDB reports this error when you try to add a
row but there is no parent row, and a
foreign key
constraint fails. Add the parent row first.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

MySQL Error Message Could not read CA key file: %s Reason for the Error ER_X509_CANT_READ_CA_KEY was added in 8.0.2.
MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.