MySql Error 150 – Foreign keys

by

From FOREIGN KEY Constraints

If you re-create a table that was
dropped, it must have a definition
that conforms to the foreign key
constraints referencing it. It must
have the right column names and types,
and it must have indexes on the
referenced keys, as stated earlier. If
these are not satisfied, MySQL returns
error number 1005 and refers to error
150 in the error message.

My suspicion is that it’s because you didn’t create foo as InnoDB, as everything else looks OK.

Edit: from the same page –

Both tables must be InnoDB tables and they must not be TEMPORARY tables.

More Related Contents:

  1. MySQL Creating tables with Foreign Keys giving errno: 150
  2. MySQL Error 1215: Cannot add foreign key constraint
  3. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  4. MySQL foreign key constraints, cascade delete
  5. How do I see all foreign keys to a table or column?
  6. MySQL Cannot Add Foreign Key Constraint
  7. Required to join 2 tables with their FKs in a 3rd table
  8. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  9. MySQL: Can’t create table (errno: 150)
  10. Basics of Foreign Keys in MySQL?
  11. Can a foreign key reference a non-unique index?
  12. How do I use on delete cascade in mysql?
  13. Add Foreign Key to existing table
  14. How to change the foreign key referential action? (behavior)
  15. How to create relationships in MySQL
  16. MySQL InnoDB foreign key between different databases
  17. MySQL Removing Some Foreign keys
  18. Force InnoDB to recheck foreign keys on a table/tables?
  19. Is it possible to reference one column as multiple foreign keys?
  20. How to insert values in table with foreign key using MySQL?
  21. Meaning of “n:m” and “1:n” in database design
  22. MySQL foreign key to allow NULL?
  23. How to use django models with foreign keys in different DBs?
  24. How to remove constraints from my MySQL table?
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. MySQL DROP all tables, ignoring foreign keys
  27. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  28. MySQL errorno 121
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. MySQL Relationships

Leave a Comment