Why Does My SQL Table Creation Fail with Error 150 (Foreign Key Constraint Issue)?

Troubleshooting MySQL Error 150: Foreign Key Constraint Issues During Table Creation

Importing a .sql file resulted in a MySQL table creation failure, displaying the error "MySQL: Can't create table './dbname/data.frm' (errno: 150)". This occurred even after dropping all existing tables and attempting a re-import from the same database.

MySQL documentation clarifies that Error 150 usually points to a problem with foreign key constraints. The key takeaway is this: when recreating a dropped table, its definition must precisely match the foreign key constraints referencing it. This includes identical column names, data types, and indexes on the referenced keys. Failure to meet these requirements leads to Error 1005, which often cites Error 150, indicating an incorrectly formed foreign key constraint. The same applies to ALTER TABLE operations; Error 150 signifies an improperly defined foreign key for the modified table.

The above is the detailed content of Why Does My SQL Table Creation Fail with Error 150 (Foreign Key Constraint Issue)?. For more information, please follow other related articles on the PHP Chinese website!