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 vote118 views1 answer
Oracle search in date columns
SQL
3 votes115 views1 answer
Postgresql db owner change
SQL
0 vote118 views1 answer
Get the previous column of a table in mysql
SQL
5 votes74 views1 answer
Alter table default value mysql
SQL
0 vote113 views1 answer
Find most frequent value in SQL column
SQL
0 vote100 views1 answer
Search In the Database using Text
SQL
3 votes108 views1 answer
Oracle detect invalid password
SQL
0 vote101 views1 answer
Edit a field mysql terminal
SQL
0 vote99 views1 answer
Running query in redshift
SQL
1 vote113 views3 answers
Drop unique key constraint in sql server
SQL