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 vote385 views1 answer
Sql query to select even numbers
SQL
0 vote326 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote306 views1 answer
Sql week commencing date
SQL
0 vote312 views1 answer
Mysql begin statement
SQL
2 votes339 views1 answer
Oracle generated column
SQL
13 votes314 views4 answers
Mysql select last 10 rows
SQL
0 vote330 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
3 votes335 views2 answers
Create schema postgres
SQL
1 vote311 views1 answer
Postgresql filter on
SQL
1 vote340 views1 answer
Postgresql define pk sequence next number
SQL