dream_of_seven的博客

原创 2021-05-18：Mysql报错 Failed to add the foreign key constraint. Missing index for constraint

Mysql报错 Failed to add the foreign key constraint. Missing index for constraint可能存在的问题：①外键和被引用的列数据类型是否相同②复合外键需注意顺序得相同(在主表中有两列A和B，在子表中创建外键就得按A和B的顺序创建) 座位表create table t_seat(O_Id Varchar(20) not null,S_Id Varchar(20) not null,S_Status Varchar(1) not