Hello everyone,
 
I'm trying to add some foreign keys to the database... It works fine for one 
table but not for another. I need to make them both children of a third table.
 
I'm using mysqld-max 4.0.16 on RedHat Linux.
 
This is the statement that I ran:
 
alter table signal_segments
add foreign key fk_signal_segments1 (db_test_id) 
references sensortest_description (db_test_id)
on delete cascade
on update cascade;
 
 
 
And this is the error message:
 
Error Code : 1216

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

Again, it works fine for another table with a similar structure...

What could be the reason? 

 

Thanks in advance,

Sergei

Reply via email to