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
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rainyear/6348896 to your computer and use it in GitHub Desktop.
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
Copy link

why we select query here??

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