sqlite reset auto increment id code example

Example 1: sqlite reset autoincrement

delete from your_table;    
delete from sqlite_sequence where name='your_table';

Example 2: sqlite reset autoincrement

UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'table_name';