mysql-error-150 – Tarik Billa

MySQL Creating tables with Foreign Keys giving errno: 150

December 30, 2022 by Tarik

These conditions must be satisfied to not get error 150 re ALTER TABLE ADD FOREIGN KEY: The Parent table must exist before you define a foreign key to reference it. You must define the tables in the right order: Parent table first, then the Child table. If both tables references each other, you must create … Read more

MySQL: Can’t create table (errno: 150)

November 12, 2022 by Tarik

From the MySQL – FOREIGN KEY Constraints Documentation: 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 correct column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not … Read more