Set start value for AUTOINCREMENT in SQLite

sqlite

Solution

Explicitly insert the `value-1` into the table, then delete the row.

Edit: the next comment down, which discusses editing the `SQLITE_SEQUENCE` table directly is probably preferable: https://stackoverflow.com/a/692871/10093

Problem

Original source