I have a table with an auto-increment column. I’d like to set it to increment at a value of n for each new record rather than 1. Is this possible? I’ve tried a few SQL statements to alter the table/column, but they all fail. Using HSQLDB Embedded.
Not with internal HSQLDB. Will always increment 1. For other databases you have to create a sequence generator instead of using the internal AutoValue.
Why do you want to increment more than 1?
Something I was taught a long time ago when I was a programmer. Allows space for insertion of record(s) without disrupting the sequence.
You could use internal Firebird instead. Have a look for CREATE SEQUENCE
Firebird: Create Sequence