MySQL错误：无法创建表（错误号：121“写入或更新时存在重复键”） [英] MySQL Error: Can't create table (errno: 121 "Duplicate key on write or update")

问题描述

我使用MySQL Workbench为数据库生成图表和代码。

当我将代码放入phpMyAdmin时，显示错误（＃1005-无法创建表 wypozyczalnia 。 wypozyczenie （错误号：121在写入或更新））

问题出在哪里？ :(
外键-表 wypozyczenie

：

CONSTRAINT符号

如果给出了CONSTRAINT符号子句，则符号值（如果使用），
在数据库中必须是唯一的。符号重复会导致
错误。如果没有给出该子句，或者在CONSTRAINT关键字后没有包含符号
，则将自动创建约束的名称
。

I use MySQL Workbench to generate diagram and code for database.

When I put code to phpMyAdmin, it show error (#1005 - Can't create table wypozyczalnia.wypozyczenie (errno: 121 "Duplicate key on write or update"))

Where is the problem? :( Foreign Keys - table wypozyczenie

Error is from this part of code:

CREATE TABLE IF NOT EXISTS `wypozyczalnia`.`wypozyczenie` (
`id_wyp` INT NOT NULL,
`data_wyp` DATE NOT NULL,
`data_odd` DATE NOT NULL,
`id_samochod` INT NOT NULL,
`id_klient` INT NOT NULL,
`id_pracownik` INT NOT NULL,
`id_plac_wyp` INT NOT NULL,
`id_plac_odd` INT NULL,
`cena` INT NULL,
`kaucja` INT NULL,
PRIMARY KEY (`id_wyp`),
INDEX `id_klient_idx` (`id_klient` ASC),
INDEX `id_samochod_idx` (`id_samochod` ASC),
INDEX `id_placowka_idx` (`id_plac_odd` ASC),
INDEX `id_pracownik_idx` (`id_pracownik` ASC),
INDEX `id_plac_wyp_idx` (`id_plac_wyp` ASC),
CONSTRAINT `id_klient_klient`
FOREIGN KEY (`id_klient`)
REFERENCES `wypozyczalnia`.`klient` (`id_klient`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `id_samochod_samochody`
FOREIGN KEY (`id_samochod`)
REFERENCES `wypozyczalnia`.`samochody` (`id_samochod`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `id_placowka_placowka`
FOREI[...]

解决方案

As the error message says: you must have used the same constraint name twice. The constraint may even be in a different table, since the constraint name must be unique in a database:

CONSTRAINT symbol

If the CONSTRAINT symbol clause is given, the symbol value, if used, must be unique in the database. A duplicate symbol results in an error. If the clause is not given, or a symbol is not included following the CONSTRAINT keyword, a name for the constraint is created automatically.

这篇关于MySQL错误：无法创建表（错误号：121“写入或更新时存在重复键”）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！