ER_NO_REFERENCED_ROW_2

Overview

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

See also: Error Codes in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 1452

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0 as error number 1452

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 1452

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0 as error number 1452

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 1452

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0 as error number 1452

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1 as error number 1452

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0 as error number 1452

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1 as error number 1452

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0 as error number 1452

EXTERNAL REFERENCES