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 vote218 views1 answer
Safe mysql
SQL
0 vote231 views2 answers
How to get max from each department in sql
SQL
1 vote199 views1 answer
T-sql find object by name
SQL
1 vote236 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote278 views1 answer
Mysql row generator
SQL
-1 vote206 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote203 views1 answer
Postgres convert exisiting column to text
SQL
0 vote199 views1 answer
Update top 100 sql
SQL
10 votes216 views1 answer
Oracle dependencies table
SQL
0 vote197 views1 answer
Sql server list user permissions
SQL