#1062 - Duplicate entry 'r40-ibm-1-2' for key 2
INSERT INTO db`.`table` (
`id` ,
`name` ,
`part` ,
`brand` ,
`category` ,
`type` ,
`note` ,
`note1` ,
`note2` ,
`note3` ,
`series` ,
`date`
)
VALUES (
NULL , 'R40', 'thinkpad', 'ibm', '1', '2', NULL , NULL , NULL , NULL , 'r series', '2008-04-18'
)
每次插入数据只要name相同就会提示:
#1062 - Duplicate entry 'r40-ibm-1-2' for key 2
而我id已经设置为auto_increment,面且`part`,`series`,`date`字段内容也不相同,为什么会提示"复制插入"呢?