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