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

18 votes208 views3 answers
Mysql query add column with default string value
SQL
0 vote216 views1 answer
Sql delete dastabase
SQL
0 vote192 views1 answer
Mql5 list all available symbols
SQL
0 vote215 views1 answer
C# mysql update statement set value to null
SQL
3 votes221 views1 answer
Oracle sleep
SQL
0 vote232 views1 answer
SQL Cut part string
SQL
14 votes213 views3 answers
Delete all records from table except sql
SQL
0 vote233 views2 answers
Dumping sql table
SQL
0 vote218 views1 answer
Inserted row count tsql
SQL
0 vote226 views1 answer
How to read the potentail error messages in ssis package
SQL