- 联合唯一约束:area_name,server_language
- 唯一约束冲突:更新值或插入
<insert id="addDomainServer" parameterType="DomainServerVO">
INSERT INTO t_domain_server
("area_name", "server_name", "server_language")
VALUES
(#{areaName}, #{serverName}, #{serverLanguage})
ON CONFLICT
(area_name,server_language)
DO UPDATE SET
server_name=#{serverName}
</insert>
- 主键冲突:不做任何操作
<insert id="addDomainServer" parameterType="DomainServerVO">
INSERT INTO t_domain_server
("area_name", "server_name", "server_language")
VALUES
(#{areaName}, #{serverName}, #{serverLanguage})
ON CONFLICT
(id)
DO NOTHING
</insert>