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 vote188 views1 answer
Add time to date sql
SQL
4 votes137 views2 answers
How to delete row in sql
SQL
0 vote142 views1 answer
Oracle webcenter content search enginer
SQL
1 vote128 views1 answer
Import local sql into remote mysql
SQL
2 votes141 views1 answer
Columns Present in a table
SQL
4 votes145 views2 answers
Sql offset
SQL
0 vote131 views1 answer
Oracle locked objects
SQL
0 vote157 views1 answer
Get relation data in mysql using query to excel
SQL
2 votes138 views1 answer
Sql column values comma separated
SQL
8 votes185 views6 answers
Insert command in sql
SQL