MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.6.9-MariaDB-1:10.6.9+maria~deb11

create table job (id serial);
insert into job () values (),(),(),(),();
create sequence job_SEQ;
select nextval(job_SEQ),nextval(job_SEQ),nextval(job_SEQ);

Records: 5  Duplicates: 0  Warnings: 0

nextval(job_SEQ)
nextval(job_SEQ)
nextval(job_SEQ)

1
2
3

set @restart_sql:=concat('alter sequence job_SEQ restart with ',(select MAX(id) + 1 from job));
prepare restart_sequence from @restart_sql;
execute restart_sequence;
deallocate prepare restart_sequence;

Statement prepared

select nextval(job_SEQ)

nextval(job_SEQ)

6