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 vote340 views1 answer
SQL server datetime compare
SQL
0 vote331 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
4 votes301 views1 answer
What are the data types in sql
SQL
0 vote300 views1 answer
Sql server udf performance
SQL
0 vote294 views1 answer
Database timezone
SQL
0 vote310 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote330 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote302 views1 answer
Update database collation in postgresql
SQL
7 votes329 views6 answers
Mysql group concat
SQL
10 votes383 views4 answers
Sql server pagination
SQL