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

26 votes176 views2 answers
Mysql workbench download
SQL
2 votes159 views1 answer
Rails execute sql
SQL
1 vote168 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote174 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote193 views1 answer
Sql remove decimal places
SQL
1 vote165 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote273 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote214 views1 answer
Mysql installer no packages found
SQL
1 vote168 views1 answer
Mariadb alter user host
SQL
0 vote191 views1 answer
MySQL import data from large CSV file
SQL