Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Set Auto Increase Num
- There is a build-in table called sqlite_sequence store the current index of auto increase number of table.
- ``` SQL
- sqlite> select * from sqlite_sequence;
- name seq
- --------- --------------------
- CASE_INFO 1284
- COMMIT_TR 0
- SVN_FILES 2774
- ```
- reset this to 0, and when insert record to table, number will change.
Add Comment
Please, Sign In to add comment