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 vote112 views1 answer
Mysql user set plugin
SQL
0 vote124 views1 answer
Datagrip execute procedure
SQL
0 vote125 views1 answer
Query params sql insert python f string
SQL
2 votes106 views1 answer
How to delete columns in sql
SQL
0 vote122 views1 answer
Modifier une valeur sql
SQL
0 vote619 views1 answer
Sql show table name in result
SQL
0 vote149 views1 answer
Postgres foreign key multiple columns
SQL
5 votes125 views1 answer
Oracle list days between two dates
SQL
15 votes141 views4 answers
Mysql export database command line
SQL
1 vote185 views1 answer
How to select department from table
SQL