mysql - SQL错误1062 : Primary key problems

Question

我的代码:

insert into userEmail ( userEmailId, userId, userEmail, userEmailTypeId )
values ('1005', 'a1a2', 'Dberkeley@fullsail.edu', '1');

我明白了......

19:06:22 insert into userEmail ( userEmailId, userId, userEmail, userEmailTypeId ) values ('1005', 'a1a2', 'Dberkeley@fullsail.edu', '1') Error Code: 1062. Duplicate entry '1005' for key 'PRIMARY' 0.00033 sec

Answer 1

这意味着您有一条 userEmailId 为 1005 的记录。

SELECT * 
FROM userEmail 
WHERE userEmailId=1005 

如果上面的查询返回一行，那就是你的证据。