HSQL identify auto increase ID
In HSQLDB you can use IDENTITY keyword to define an auto-increment column, normally, this is the primary key. Review below examples : 1. IDENTITY – Default By default, the IDENTITY value is start with zero. CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, name VARCHAR(30), email VARCHAR(50) ); INSERT INTO users (name, email) VALUES …