Home >Database >Mysql Tutorial >MySQL出现1005
MySQL出现1005
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 17:15:441547browse
环境：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.
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Java操作MongoDBNext article：Spring管理MongoDB