insert conflict do update

insert into aaa (id, agent_id, mname)
values ('asd','aaa','asdasd5'),('ddd','aaa1','asdasd4')
on conflict (id) do update set mname =excluded .mname ;

 
posted @ 2022-03-27 10:51  Mr.Liu08  阅读(24)  评论(0编辑  收藏  举报