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

1 vote122 views1 answer
Firebase bigquery cloud message
SQL
0 vote143 views2 answers
Close external port 3306 with iptables
SQL
0 vote137 views1 answer
Spark sql grows beyond 64 kb
SQL
-1 vote129 views2 answers
On update cascade
SQL
1 vote136 views1 answer
Oracle create program if no exists
SQL
2 votes143 views2 answers
Create temporary table in mysql
SQL
0 vote152 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote140 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote299 views1 answer
The package java.sql is not accessible
SQL
0 vote157 views1 answer
Repeatable read trong sql server
SQL