h2 auto increment and unique
snippet in sql

h2 auto increment and unique

user7889

drop table test;
create table test(id bigint auto_increment, name varchar(255));
insert into test(name) values('hello');
insert into test(name) values('world');
select * from test;