Guest User

Untitled

a guest
Jul 20th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. # Set Auto Increase Num
  2. There is a build-in table called sqlite_sequence store the current index of auto increase number of table.
  3. ``` SQL
  4. sqlite> select * from sqlite_sequence;
  5. name seq
  6. --------- --------------------
  7. CASE_INFO 1284
  8. COMMIT_TR 0
  9. SVN_FILES 2774
  10. ```
  11. reset this to 0, and when insert record to table, number will change.
Add Comment
Please, Sign In to add comment