HomeMySQLMySQL Error 1216 – ER_NO_REFERENCED_ROW

MySQL Error 1216 – ER_NO_REFERENCED_ROW

MySQL Error Message

Cannot add or update a child row: a foreign key
constraint fails

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 Ignored the innodb-redo-log-capacity option in the Innodb read-only mode. Server is using active redo log files. Reason...
  • MySQL
  • November 17, 2022
MySQL Error Message This member is configured with a group_replication_paxos_single_leader option value of 1 and it is trying to join...
  • MySQL
  • November 17, 2022
MySQL Error Message Record has both instant and version bit set. Reason for the Error ER_CHECK_TABLE_INSTANT_VERSION_BIT_SET was added in 8.0.32.
  • MySQL
  • November 17, 2022