Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5RgwDTn5zeAoPM1yXxeRkm-YUseiccsUNQxcQeBPK3Td3' for key 'PRIMARY' ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: {call pro_read_one (?, ?, ?)} ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5RgwDTn5zeAoPM1yXxeRkm-YUseiccsUNQxcQeBPK3Td3' for key 'PRIMARY' ; SQL []; Duplicate entry '5RgwDTn5zeAoPM1yXxeRkm-YUseiccsUNQxcQeBPK3Td3' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5RgwDTn5zeAoPM1yXxeRkm-YUseiccsUNQxcQeBPK3Td3' for key 'PRIMARY'
2条回答 默认 最新
- A_Miao_shao 2015-01-08 10:08关注
BEGIN
DECLARE ISEXIST INT DEFAULT 0;
DECLARE nextval int DEFAULT 0;SELECT COUNT(1) INTO ISEXIST FROM TBL_RES_READ C WHERE C.RES_ID = RID AND C.USER_ID = UID;
IF ISEXIST = 0 THEN
INSERT INTO TBL_RES_READ(RES_ID, USER_ID, CREATE_DATE) VALUES (RID, UID, NOW());
END IF;call get_next_version('seq_res_version',@next_val);
select @next_val into nextval;
update tbl_res_user_unread u
set u.status_new = 0, u.comment_new = 0, u.version = nextval
where u.res_id = rid and u.user_id = uid;SET RES = 1;
END
存储过程里面这么写的解决 无用评论 打赏 举报
悬赏问题
- ¥15 素材场景中光线烘焙后灯光失效
- ¥15 请教一下各位,为什么我这个没有实现模拟点击
- ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
- ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
- ¥20 有关区间dp的问题求解
- ¥15 多电路系统共用电源的串扰问题
- ¥15 slam rangenet++配置
- ¥15 有没有研究水声通信方面的帮我改俩matlab代码
- ¥15 ubuntu子系统密码忘记
- ¥15 保护模式-系统加载-段寄存器