1005 - Can't create table 'xxx' (errno: 150)

updated at 

Apply OS: Windows, macOS, Linux, iOS

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

 

There are some possible cases that might cause failure on creating foreign keys or tables on MySQL database. These errors are related to MySQL itself.

Example cases:

  1. If the two fields (Field and Referenced Field) are using incompatible field type, MySQL will return the error.
  2. If you use "On Delete Set Null" but the field doesn't allow null, MySQL will return the error.

There may be various cases to cause the same error. For more information, please feel free to visit at - https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html

Related articles

Have more questions?
Submit Ticket