Hi,
With mysql-4.0.20, I have a problem inserting data with foreign key
references, MySQL saying ERROR 1216: Cannot add or update a child row:
a foreign key constraint fails
The message is confusing because a parent record in parent table exists
!?
The "show innodb status; " command prints :
CONSTRAINT `C67125` FOREIGN KEY (`affaire_ref`) REFERENCES `affaire`
(`reference`) ON DELETE CASCADE ON UPDATE CASCADE
Trying to add to index `consultation_ref` tuple:
DATA TUPLE: 2 fields;
0: len 23; hex 544553545f4154585f32202d20414f4f202d2041415043; asc
TEST_AT;; 1: len 4; hex 8000000d; asc ;;
But the parent table `AJAO/affaire` does not currently exist!
Any help would be appreciated.
Regards