MySQL error 1005:can ' t create TABLE (ERRNO:150) solution

The error message of MySQL error 1005:can ' t create TABLE (ERRNO:150) When establishing referential constraints in MySQL results in the inability to establish referential constraints.

A rough picture of what's wrong

1, foreign key reference type is not the same, the primary key is an int foreign key is char

2. Columns referenced in the primary table cannot be found

3. Inconsistent character encoding of primary key and foreign key

4, if you want to establish a foreign key, you must first establish an index. There is an error when indexing is not established.

MySQL error 1005:can ' t create TABLE (ERRNO:150) solution