mysql设置外码错误_mysql外键约束错误地形成错误

甚至我遇到了与mysql和liquibase相同的问题。

所以这就是问题所在：

要从中引用其他表的列的表在数据类型的情况下或在数据类型的大小方面是不同的。

Error appears in below scenario:

Scenario 1:

Table A has column id, type=bigint

Table B column referenced_id type varchar(this column gets the value from the id column of Table A.)

Liquibase changeset for table B:

referencedTableName="A" **baseColumnNames="referenced_id**"

referencedColumnNames="id" baseTableName="B" />

Table A changeSet:

Solution:

correct the type of table B to bigint because the referenced table has type bigint.

Scenrario 2:

The type might be correct but the size might not.

e.g. :

Table B : referenced column type="varchar 50"

Table A : base column type ="varchar 255"

Solution change the size of referenced column to that of base table's column size.