您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

MySQL出现1005

2024/4/27 20:20:15发布23次查看
环境:navicatformysql8.2 + mysql sever 5.1,问题:创建外键出现105错误,如下图:
环境:navicatformysql8.2 + mysql sever 5.1
问题:创建外键出现105错误,如下图:
解决:删除引用表,,重新创建。
stackoverflow上面对105错误的解释:
if you re-create a table that was dropped, it must have a definitionthat conforms to the foreign key constraints referencing it. it must have theright column names and types, and it must have indexes on the referenced keys,as stated earlier. if these are not satisfied, mysql returns error number 1005and refers to error 150 in the error message.
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product