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

2 votes342 views2 answers
How to rename column name in sql server using query
SQL
0 vote326 views1 answer
Download mysql database to excel in android studio
SQL
23 votes331 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote323 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
3 votes347 views2 answers
Sqlite print all column names
SQL
0 vote336 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote343 views1 answer
Mysql join only one column
SQL
-1 vote343 views2 answers
Postgresql user permissions to database
SQL
0 vote333 views2 answers
SQL BULK INSERT
SQL
2 votes337 views1 answer
Mysql Incorrect column specifier for column
SQL