1
vote
HSQLDB get next value for IDENTITY column
You can get the last identity value already inserted, but not the next one.
Use the IDENTITY() function. The value is useful for inserting into another table which has a foreign key referencing the ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
hsqldb × 9postgresql × 2
database-design × 1
query × 1
select × 1
migration × 1
transaction-log × 1
group-by × 1
sqlite × 1
date × 1
identity × 1
auto-increment × 1
character-set × 1
encoding × 1
distinct × 1
debugging × 1
database-agnostic × 1
h2 × 1
derby × 1