Re: Referential Integrity in mySQL

2002-07-16 Thread Egor Egorov
Adnan, Tuesday, July 16, 2002, 2:18:22 PM, you wrote: AY> I am having a problem in referential Integrity in mySQL. I have AY> created a parent table which have deptno from 1-10. When i insert a row in AY> child table that has deptno as foreign key it accept a value 11 wh

Referential Integrity in mySQL

2002-07-16 Thread Adnan Yaqoob
Hello all, I am having a problem in referential Integrity in mySQL. I have created a parent table which have deptno from 1-10. When i insert a row in child table that has deptno as foreign key it accept a value 11 which is actually not present in parent table. Can