Entry

Database: MySql: Error: 1216: (23000): Cannot add or update fails: a foreign key constraint fails

Jul 6th, 2008 13:21
Knud van Eeden, dman,

----------------------------------------------------------------------
--- Knud van Eeden --- 29 May 2021 - 10:34 pm ------------------------
Database: MySql: Error: 1216: (23000): Cannot add or update fails: a 
foreign key constraint fails
---
Possible cause:
You are trying to insert a not existing foreign key
(e.g. row nr 23)
---
Possible solution:
Check if the foreign key exists in the foreign key table.
If not, possibly insert it, or use another valid and existing
foreign key.
---
---
Internet: see also:
---
Database: Relational: MySql: Link: Overview: Can you give an overview 
of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35331/fid/52
----------------------------------------------------------------------