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 vote277 views1 answer
Oracle stop
SQL
0 vote285 views1 answer
How to add timestamp column in mysql
SQL
0 vote262 views2 answers
SQL Server Standard
SQL
3 votes264 views1 answer
MySQL DELETE JOIN
SQL
7 votes297 views4 answers
Index in mysql
SQL
1 vote277 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
9 votes287 views6 answers
Check constraint in sql
SQL
3 votes274 views1 answer
Define REGEXP?
SQL
6 votes253 views1 answer
Rank function in oracle with example
SQL
0 vote283 views1 answer
Groupby sort sql hive
SQL