Showing posts with label error. Show all posts
Showing posts with label error. Show all posts

Tuesday, 10 February 2015

MYSQL error code 1005

Error Code 10005
 While adding foreign key constraint i got 1005 error code, weird  thing about this error is that it tells "can't create table sql 150 error"

Possible reason:
1. Data type of primary & foreign key mismatch.
2. Length of data type different ex: primary key = int(10) & foreign key = int(11)
3. primary column may already drop.
4. constraint name already exist in database.