MySQL出现1005 - Can't create table 'zxct.#sql-1acc_a' (errno: 150)解决

最新推荐文章于 2023-04-03 21:28:46 发布

最新推荐文章于 2023-04-03 21:28:46 发布 · 253 阅读

文章标签：

#数据库

本文介绍在使用Navicat for MySQL 8.2 和 MySQL Server 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.

参考资料：

http://stackoverflow.com/questions/4061293/mysql-cant-create-table-errno-150