MYSQL foreign key creation failure Cant create table records

This error occurs because mysql has never been able to support the problem. Unfortunately, it does not specify which problem will lead to the above error, below I listed the common causes of this terrible 150 error, and sorted by the possibility size, known reasons:

This error occurs because the mysql tutorial has never been well-supported. Unfortunately, it does not indicate which problem will lead to the above error, below I listed the common causes of this terrible 150 error, and sorted by the possibility size, known reasons:

1. the type or size of two fields are not strictly matched. For example, if one field is INT (10), the foreign key must be set to INT (10) instead of INT (11) it cannot be TINYINT. you must use the SHOW command to check the field size, because some query browsers sometimes display both int (10) and int (11) as integer. In addition, you must determine whether one of the two fields is SIGNED and the other is UNSIGNED. The two fields must be exactly consistent,