H2 auto increment and unique

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;

Source: stackoverflow.com

Similar codes

1 vote106 views1 answer
Altrer name column postgres
SQL
7 votes112 views1 answer
Query postgres delete duplicates
SQL
5 votes99 views1 answer
Invalid column name sql
SQL
4 votes112 views1 answer
Id increment ms sql server
SQL
3 votes99 views1 answer
Oracle get trigger ddl
SQL
1 vote143 views1 answer
Apex run 404
SQL
0 vote99 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
1 vote97 views1 answer
Postgresql if 0 then 1
SQL
0 vote119 views1 answer
Insert value in identity
SQL
9 votes252 views2 answers
Current date in postgresql minus 1 day
SQL