Duplicate key error in MySQL (Duplicate key name '')
来源:互联网 发布:sql delete select 编辑:程序博客网 时间:2024/06/05 11:06
The below query is resulting in an error. I created this query in MySQL Workbench
ErrorSQL query:-- ------------------------------------------------------- Table `smsdb`.`IntSupervisor`-- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `smsdb`.`IntSupervisor` ( `int_supr_id` VARCHAR( 32 ) NOT NULL , `cent_id` INT NOT NULL , INDEX `fk_IntSupervisor_Person1_idx` ( `int_supr_id` ASC ) , INDEX `fk_IntSupervisor_Center1_idx` ( `cent_id` ASC ) , PRIMARY KEY ( `int_supr_id` ) , CONSTRAINT `fk_parent_id` FOREIGN KEY ( `int_supr_id` ) REFERENCES `smsdb`.`Staff` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT , CONSTRAINT `fk_center_id` FOREIGN KEY ( `cent_id` ) REFERENCES `smsdb`.`Center` (`cent_id` ) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB;
I got an error message on execution:
MySQL said: Documentation #1022 - Can't write; duplicate key in table 'intsupervisor'
If anyone has any ideas on how I can resolve this issue, please guide me in the right direction. Thanks!
Welcome to relational databases in MySQL! ;)
You can't have two foreign keys named the same thing across the whole query.
PRIMARY KEY ( `int_supr_id` ) ,
CONSTRAINT `fk_parent_id` FOREIGN KEY ( `int_supr_id` )
In the above statement, you can't redefine the index type on a single column.
So, how do I fix this annoying error?
Based on the structure of the database, you need to remove one of the two lines above. I'm guessing your linking to another table from the one you are creating, so I recommend replacing ...
PRIMARY KEY ( `int_supr_id` ) , CONSTRAINT `fk_parent_id` FOREIGN KEY ( `int_supr_id` )
With the following:
CONSTRAINT `fk_parent_id` FOREIGN KEY ( `int_supr_id` )
(if the above doesn't work, you likely need to specify a table name for the foreign key)
2.--
-- Table structure for table `payment`
--
DROP TABLE IF EXISTS `payment`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `payment` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`entry_ID` int(11) NOT NULL,
`account_ID` int(11) NOT NULL,
`amount` double NOT NULL,
`pmt_form` varchar(20) NOT NULL,
`reference` varchar(120) DEFAULT NULL,
`COID` int(11) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
KEY `FK_PAYMENT_ACCOUNT` (`account_ID`),
KEY `FK_PAYMENT_ENTRY` (`entry_ID`),
CONSTRAINT `FK_PAYMENT_ACCOUNT` FOREIGN KEY (`account_ID`) REFERENCES `account` (`ID`),
CONSTRAINT `FK_PAYMENT_ENTRY` FOREIGN KEY (`entry_ID`)REFERENCES `register_entry` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
一开始一个是entry_ID 一个是 entry_id 导致报错。后来改为一样 导入数据通过
- Duplicate key error in MySQL (Duplicate key name '')
- ERROR:duplicate key in table MYsql
- MySQL on duplicate key
- mysql key duplicate
- mysql制作外键出现duplicate key name错误
- MySQl的ON DUPLICATE KEY
- MySQL - ON DUPLICATE KEY UPDATE
- MySQl的ON DUPLICATE KEY
- mysql on duplicate key update
- mysql ON DUPLICATE KEY UPDATE
- mysql on duplicate key update
- mysql ON DUPLICATE KEY UPDATE
- e11000-duplicate-key-error-index-in-mongodb-mongoose
- mysql报错Error Code: 1022. Can't write; duplicate key in table `xxx`
- MySQL --- SQL Error: 1062: Duplicate entry '2147483647' for key 'PRIMARY'
- Mysql错误提示:Error: Duplicate entry '0' for key 'PRIMARY'
- MySQL ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
- mysql "Duplicate entry '127' for key 1"
- win7 x64环境下 python3.2 nltk3.0及相关工具包的安装
- 1071. Speech Patterns
- 队列的入列和出列
- Activity的四种launchMode
- HDU 1506 Largest Rectangle in a Histogram(dp)
- Duplicate key error in MySQL (Duplicate key name '')
- Leetcode_merge-two-sorted-lists
- onselectstart事件 ondragstart事件:禁止鼠标在网页上拖动.oncontextmenu事件:取消鼠标右键
- java 随机抽奖程序
- TCP实现图片上传
- android 学习: 基础知识
- C++学习之sqlite
- qmake
- 在Ubuntu上配置arm-linux-gcc环境变量有感