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

5 votes207 views1 answer
Oracle nls instance
SQL
13 votes199 views6 answers
Mysql update from select
SQL
3 votes210 views2 answers
Get current year sql
SQL
0 vote203 views1 answer
Mysql update from n to 100
SQL
3 votes195 views3 answers
Remove all spaces from string sql
SQL
0 vote218 views1 answer
Update sql sintax
SQL
0 vote209 views1 answer
Oracle gather table statistics
SQL
20 votes201 views4 answers
Sqlite create table if not exists
SQL
1 vote206 views2 answers
Mysql remove first and last character from string
SQL
2 votes238 views1 answer
Datefromparts mssql
SQL