MySQL + PostgreSQL批量插入更新insertOrUpdate，Java全套视频

等等…

二、postgres中insertOrUpdate代码实例

1、创建user表

CREATE TABLE public.t_user (

username varchar(100) NOT NULL,

age int4 NOT NULL DEFAULT 0,

“password” varchar(100) NULL,

deleted int4 NULL,

created_time timestamp NULL

);

CREATE UNIQUE INDEX t_user_union_name_age_password ON public.t_user USING btree (username, password, age);

2、简单的方式实现

insert

into

public.t_user (username , password,age,created_time)

values (‘zs’, ‘123’, 18,now()), (‘ls’, ‘123456’, 19,now()),(‘ww’, ‘123’, 20,now())

on conflict (username, age,password) do update set username = excluded.username,age = excluded.age,password = excluded.password,created_time = excluded.created_time

3、利用unnest函数实现

insert

into

public.t_user (username , password,age,created_time)

values (unnest(array[‘zs’, ‘ls’,