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

10 votes199 views4 answers
Drop primary key
SQL
0 vote203 views1 answer
Insert using condition postgres
SQL
0 vote381 views1 answer
Multiple row join
SQL
0 vote292 views1 answer
Sql if clause within where clause
SQL
0 vote188 views1 answer
Backup a table in sql
SQL
0 vote229 views1 answer
Sql quary stuf
SQL
0 vote193 views3 answers
Select random sql
SQL
1 vote215 views1 answer
Sql headers delphi
SQL
0 vote208 views1 answer
Python connect to mysql in settings.py
SQL
-1 vote212 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL