批量往表里插入数据时,存在主键重复的情况
create sequence seq_tablename_id;
select setval('seq_tablename_id', max(id)) from tablename;
insert into tablename(id) values(nextval('seq__tablename_id'));
批量往表里插入数据时,存在主键重复的情况
create sequence seq_tablename_id;
select setval('seq_tablename_id', max(id)) from tablename;
insert into tablename(id) values(nextval('seq__tablename_id'));