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 vote240 views1 answer
Sql composite key
SQL
1 vote248 views1 answer
Sql where max date
SQL
0 vote251 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote228 views1 answer
Mysql into outfile with headers
SQL
2 votes225 views1 answer
Select * from table where name like
SQL
13 votes259 views4 answers
What is sql
SQL
1 vote262 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
3 votes225 views1 answer
Mysql set field unique
SQL
0 vote237 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote252 views1 answer
How to write if case in select query in select statement
SQL