Skip to content

Instantly share code, notes, and snippets.

@rainyear

rainyear/sqlite_truncate_cmd.sql

Last active October 19, 2017 15:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rainyear/6348896 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rainyear/6348896 to your computer and use it in GitHub Desktop.
Download ZIP
TRUNCATE TABLE for sqlite.
Raw
sqlite_truncate_cmd.sql
delete from `TABLE`;
select * from sqlite_sequence;
update sqlite_sequence set seq=0 where name=`TABLE`;
@NaveenDA

NaveenDA commented Oct 19, 2017

Copy link
Copy Markdown

why we select query here??

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment