472,145 Members | 1,406 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Foreign key Constraint Fails in MYSQL 5.0.18


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
Dec 18 '06 #1
1 2048
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.