MySQL error number 1005, table creation failed

MySQl Error: 1005 SQLSTATE: HY000

If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to error 150, that means a foreign key definition would be .

Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)
Message: Can’t create table ‘%s’ (errno: %d)

 

For any query or issue, feel free to discuss on http://discuss.eduguru.in

Satya Prakash

VOIP Expert: More than 8 years of experience in Asterisk Development and Call Center operation Management. Unique Combination of Skill Set as IT, Analytics and operation management.

Leave a Reply