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 vote134 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote181 views1 answer
Amount of entries in a table psql
SQL
0 vote191 views1 answer
Systems sql
SQL
1 vote177 views1 answer
Multiple count in sql
SQL
1 vote231 views1 answer
Tsql create unique index composite
SQL
0 vote171 views1 answer
Selects all the columns from the sailors table
SQL
1 vote169 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote189 views1 answer
Connect to ssms with python
SQL
1 vote160 views1 answer
Deleting database in sql
SQL
0 vote179 views1 answer
Oracle list subpartitions
SQL