语句如下
INSERT INTO doctor(name,hospital_id) VALUES (#{doctor.name},#{doctor.hospitalId})
ON DUPLICATE KEY UPDATE hospital_id=#{doctor.hospitalId},name=#{doctor.name};
先执行
INSERT INTO doctor(name,hospital_id) VALUES (#{doctor.name},#{doctor.hospitalId})
当insert语句出现唯一索引重复时执行
UPDATE doctor SET hospital_id=#{doctor.hospitalId},name=#{doctor.name};