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

5 votes239 views1 answer
Update sql user password
SQL
0 vote256 views1 answer
Show size of all tables postgres
SQL
0 vote289 views10 answers
Sql statement checker corrector
SQL
0 vote245 views1 answer
Concatenate columns in table
SQL
0 vote252 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote261 views1 answer
Create bdd mysql
SQL
2 votes252 views1 answer
Import large .sql files into lampp
SQL
4 votes296 views3 answers
Postgres drop all tables
SQL
4 votes255 views2 answers
REST API
SQL
1 vote233 views3 answers
String to int mysql
SQL