error #1005 - Can't create table `testdb`.`blog` (errno: 150 "Foreign key constraint is incorrectly formed")?

Question

CREATE TABLE blog
(
    blog_id BIGINT(255),
    email VARCHAR(255),
    blog_title CHAR(255),
    blog_content TEXT(5000),
    PRIMARY KEY (blog_id),
    FOREIGN KEY (email) REFERENCES detail(email)
);

Possible duplicate of [Error Code: 1005. Can't create table '...' (errno: 150)](http://stackoverflow.com/questions/9018584/error-code-1005-cant-create-table-errno-150) — user1140237, Dec 28 '15 at 06:31

score 0 · Answer 1 · answered Dec 28 '15 at 06:51

0

This link can solve your problem

answered Dec 28 '15 at 06:51

Vipin Jain

3,686
16
35

error #1005 - Can't create table `testdb`.`blog` (errno: 150 "Foreign key constraint is incorrectly formed")?

1 Answers1