运维网's Archiver
论坛
›
MySQL运维
› MySQL加外键报错Foreign key constraint is incorrectly formed
bingtuag
发表于 2016-10-19 08:27:27
MySQL加外键报错Foreign key constraint is incorrectly formed
在服务器上给MySQL中的表加外键,报错
SQL Error (1005): Can't create table 'xxxxx' (errno: 150) Foreign key constraint is incorrectly formed
检查了SQL,没错,然后发现其中一个表的引擎是MyISAM,将其改为InnoDB后,运行通过
页:
[1]
查看完整版本:
MySQL加外键报错Foreign key constraint is incorrectly formed