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 vote179 views1 answer
Psql list view rules
SQL
0 vote180 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes274 views1 answer
Oracle list grants on package
SQL
10 votes169 views1 answer
Create table oracle
SQL
0 vote179 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
1 vote265 views1 answer
Create new table from old table with data
SQL
0 vote202 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
2 votes162 views1 answer
Ifnull postgres
SQL
0 vote185 views1 answer
Connect by query in oracle
SQL
0 vote186 views1 answer
Storing RGBA in mysql db
SQL