Foreign key Constraint Fails in MYSQL 5.0.18

[somaskarthic]

Hi

I'm using MySQL 5.0.18 . Here i'm unable to assign foreign key. Though it is assigned , while adding a row to a child table , it violates the foreign key rule.
Database engine is MyISAM. It is mentioned in MySQL document , that MyISAM (default one) will not support foreign key constraints. Hence , while creating table i maually modified the syntax as ,

create table table1 (... ) engine = innodb

But still , i'm unable to assign and use foreign keys in MySQL Database.

Let me know the solution

Thanks in advance
somaskarthic

[ronverdonk]

Our members could easier see your problem and be more inclined to help you out (or try to) if you showed us the SQL you are using or have used.

Ronald :cool: