文档解释
Error number: MY-012034; Symbol: ER_IB_MSG_209; SQLSTATE: HY000
Message: %s
Error number: MY-012034; Symbol: ER_IB_MSG_209; SQLSTATE: HY000
MySQL Error number MY-012034; Symbol ER_IB_MSG_209; and SQLSTATE HY000 is an error associated with the InnoDB storage engine. This error is specific to foreign key constraints.
Error Explanation
This error occurs when a foreign key constraint fails. Specifically, this error occurs when a value being added to a record of a InnoDB table violates the foreign key constraint.
Common Cases
This error is typically seen when creating a specific type of relationship between a couple of tables. When you have a “has many” relationship between a parent table and a child table, typically you create a foreign key constraint on the child table which references a specific value in the parent table’s unique ID. This error occurs when the value being added to the FK field of the child’s record does not exist in the parent.
Solution
The solution is to make sure that the foreign key value being added to the child record DOES exist in the parent table’s primary key field. This can be done programmatically or manually when inserting records into the table. If the record that must exist in the parent is not there, then you must create it.
