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 vote190 views2 answers
Nested query
SQL
0 vote184 views1 answer
Can sqldatareader be null
SQL
0 vote176 views1 answer
Install mysql for fedora 34
SQL
3 votes206 views1 answer
How to add unique constraint in mysql table
SQL
0 vote171 views1 answer
Sqlite version check
SQL
0 vote188 views1 answer
Postgresql not in alternative
SQL
0 vote173 views1 answer
Sql get table last modified time
SQL
0 vote209 views1 answer
Sql query inline if
SQL
0 vote178 views1 answer
Start and stop mysql
SQL
22 votes177 views4 answers
Show list of users in mysql
SQL