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 vote144 views1 answer
How to create a table based on another table in mysql
SQL
-1 vote150 views3 answers
PS5
SQL
0 vote138 views1 answer
Sql cheetsheet
SQL
0 vote169 views1 answer
Get initials name in sql
SQL
1 vote147 views1 answer
Postgres cast as currency format
SQL
0 vote147 views1 answer
Drop table BigQuery table columns
SQL
0 vote129 views1 answer
Postgres select except
SQL
0 vote161 views1 answer
Cannot start database server xampp mac os
SQL
2 votes121 views2 answers
How to get capital letter first in sql
SQL
0 vote141 views1 answer
Wordpress delete post revisions older than date "sql"
SQL