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

7 votes189 views2 answers
Mysql get year from date
SQL
0 vote193 views1 answer
One table with another
SQL
0 vote208 views3 answers
Insert query in ci
SQL
-1 vote205 views1 answer
Module operator in oracle sql
SQL
7 votes237 views1 answer
Sql disable safe mode
SQL
0 vote192 views1 answer
Why we have to set the password for my sql server
SQL
14 votes188 views2 answers
How to auto increment in sql
SQL
0 vote189 views1 answer
Will graphql replace sql
SQL
0 vote179 views1 answer
Remove binlog mysql
SQL
-1 vote186 views1 answer
How to check table exists or not in postgresql
SQL