当尝试创建表时遇到ERROR 1005 (errno 121)，通常是由于表已存在、.frm文件残留或外键约束名称冲突。解决方法是检查并确保主键名在整个数据库中唯一，或者更改外键约束的名称。通过更改变量名，成功解决了建表问题。
ERROR 1005: Can't create table (errno: 121)
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data dictionary, though the .frm file for the table has been deleted. This is the most common reason for getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key constraint name. Constraint names must be unique in a database, like table names are.
意思是：
最低0.47元/天 解锁文章
扫一扫
3556
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
