Mysql无法创建表errno 121

时间:2021-09-09 01:08:44

Why am I getting this error? I don't have any foreign keys

为什么我收到此错误?我没有任何外键

drop table if exists t_issue;
SET foreign_key_checks = 0;SET storage_engine=INNODB;
CREATE TABLE `t_issue` (
`id_issue` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`fk_project` int(11) DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`estimated_due_date` date DEFAULT NULL,
`due_date` date DEFAULT NULL,
`done_ratio` int(11) DEFAULT NULL,
`fk_status` int(11) DEFAULT NULL,
`fk_assigned_to` int(11) DEFAULT NULL,
`fk_owner` int(11) DEFAULT NULL
) ENGINE=innodb DEFAULT CHARSET=latin1

1 个解决方案

#1


28  

Mysql can't create table errno 121

You will get this message if you are trying to add a constraint with a name that is already used somewhere else.

如果您尝试使用已在其他位置使用过的名称添加约束,则会收到此消息。

To check constraints, use the following SQL query:

要检查约束,请使用以下SQL查询:

SELECT
    constraint_name,
    table_name
FROM
    information_schema.table_constraints
WHERE
    constraint_type = 'FOREIGN KEY'
AND table_schema = DATABASE()
ORDER BY
    constraint_name;

Reference: https://dba.stackexchange.com/questions/425/error-creating-foreign-key-from-mysql-workbench

参考:https://dba.stackexchange.com/questions/425/error-creating-foreign-key-from-mysql-workbench

See also: SQL - error code 1005 with error number 121

另请参阅:SQL - 错误代码1005,错误号121

#1


28  

Mysql can't create table errno 121

You will get this message if you are trying to add a constraint with a name that is already used somewhere else.

如果您尝试使用已在其他位置使用过的名称添加约束,则会收到此消息。

To check constraints, use the following SQL query:

要检查约束,请使用以下SQL查询:

SELECT
    constraint_name,
    table_name
FROM
    information_schema.table_constraints
WHERE
    constraint_type = 'FOREIGN KEY'
AND table_schema = DATABASE()
ORDER BY
    constraint_name;

Reference: https://dba.stackexchange.com/questions/425/error-creating-foreign-key-from-mysql-workbench

参考:https://dba.stackexchange.com/questions/425/error-creating-foreign-key-from-mysql-workbench

See also: SQL - error code 1005 with error number 121

另请参阅:SQL - 错误代码1005,错误号121