469,925 Members | 1,519 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,925 developers. It's quick & easy.

Foreign key Constraint Fails in MYSQL 5.0.18

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
Dec 18 '06 #1
1 2000
ronverdonk
4,258 Expert 4TB
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:
Dec 18 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Jeremiah Jacks | last post: by
reply views Thread by John Towell | last post: by
5 posts views Thread by coosa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.