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 vote154 views1 answer
Shell script to log mysql cpu usage
SQL
1 vote130 views1 answer
How to use a trigger to validate input data
SQL
1 vote155 views1 answer
Sqlserver create table from select
SQL
8 votes215 views1 answer
Oracle search code in packages
SQL
0 vote162 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote140 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote137 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote147 views1 answer
Search starting with mysql
SQL
25 votes155 views3 answers
Mysql command show tables
SQL
0 vote149 views1 answer
Rows, INSERT INTO, Returning
SQL