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 votes155 views3 answers
Replace null in sql
SQL
0 vote145 views1 answer
How to see password mysql vestacp
SQL
0 vote156 views1 answer
Sql value exists in column
SQL
1 vote163 views1 answer
Mysql not supported auth mode
SQL
2 votes149 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
3 votes157 views2 answers
Create schema postgres
SQL
0 vote140 views1 answer
Call function in query sql server
SQL
48 votes242 views3 answers
Psql create database
SQL
0 vote157 views1 answer
Tinydb add table
SQL
1 vote140 views2 answers
How to check username in mysql command line
SQL