Duplicate entry ‘1‘ for key ‘sys_patient_info.user_id‘

本文主要是介绍Duplicate entry ‘1‘ for key ‘sys_patient_info.user_id‘，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

报错信息

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'sys_patient_info.user_id' ### The error may exist in file [D:\learn\Project\RuoYi-Vue-master\ruoyi-system\target\classes\mapper\system\SysUserMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into sys_patient_info(emergency_contact, emergency_contact_phone, user_id) values (?, ?, ?) ### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'sys_patient_info.user_id' ; Duplicate entry '1' for key 'sys_patient_info.user_id'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'sys_patient_info.user_id'

报错原因

这个错误信息表明您在尝试向sys_patient_info表中插入一条新记录时，遇到了主键或唯一索引冲突的错误。具体来说，错误信息指出Duplicate entry '1' for key 'sys_patient_info.user_id'，意味着您试图插入的user_id值1已经在sys_patient_info表的user_id字段中存在，违反了唯一性约束。

解决方法

把user_id的值改成表中没有的数据

这篇关于Duplicate entry ‘1‘ for key ‘sys_patient_info.user_id‘的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---