Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
cannot add foriegn key constraint
vutharadi prathyusha
Aug 15 2015 1:47 AM
489
Reply
Hi,
In MySql command prompt i getting this error.Cannot add foriegn key constraint .
CREATE TABLE Contibutors (
Id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
MagazineId INT(6) NOT NULL,
Name VARCHAR(50) NOT NULL,
Email VARCHAR(100),
Guid VARCHAR(36) NOT NULL,
ContentSubmitted BIT,
CreatedOn DATETIME,
FOREIGN KEY (MagazineId) REFERENCES Magazine(Id)
);
If i do any thing wrong here.Will you please tell me.
Thanks,
prathyusha
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
unable to connect to the mysql
Syntax error in MySql