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

0 vote268 views1 answer
Change data type in mysql
SQL
0 vote277 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote294 views1 answer
Mysql size int
SQL
0 vote270 views1 answer
Acual month sql
SQL
0 vote299 views1 answer
Compare subqueries oracle
SQL
18 votes280 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
35 votes289 views6 answers
Postgres
SQL
0 vote283 views1 answer
Sql server create constraint
SQL
0 vote294 views1 answer
Sql commands in android
SQL
1 vote294 views1 answer
Oracle compile schema
SQL