insert into test
(a, b, c)
values
(#{a}, #{b}, #{c}) on conflict
(a, b) do update set c = excluded.c
insert into test
(a, b, c)
values
(#{a}, #{b}, #{c}) on conflict
(a, b) do nothing
其中conflict里面写唯一索引名称。
insert into test
(a, b, c)
values
(#{a}, #{b}, #{c}) on conflict
(a, b) do update set c = excluded.c
insert into test
(a, b, c)
values
(#{a}, #{b}, #{c}) on conflict
(a, b) do nothing
其中conflict里面写唯一索引名称。