欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

MySQL出现1005

程序员文章站 2022-03-29 09:02:40
...

环境:NavicatforMysql8.2 + MySQL Sever 5.1,问题:创建外键出现105错误,如下图:

环境:NavicatforMysql8.2 + MySQL Sever 5.1

问题:创建外键出现105错误,如下图:

MySQL出现1005

解决:删除引用表,,重新创建。

*上面对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.

MySQL出现1005