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

2 votes373 views2 answers
How to add not null constraint in sql
SQL
0 vote357 views5 answers
How to make trigger in phpmyadmin
SQL
14 votes353 views4 answers
Remove record from table sql
SQL
1 vote368 views1 answer
Oracle difference between two dates in years
SQL
1 vote350 views1 answer
Access the postgres psql
SQL
1 vote381 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
1 vote282 views1 answer
How to run sql script
SQL
1 vote347 views1 answer
Get parameter value in mysql trigger
SQL
1 vote355 views2 answers
Mysql show views
SQL
0 vote349 views3 answers
Query string not ending with with vowels
SQL