The SQLite database is emptied and the ID starts at 0

If you understand the structure of the SQLite database, it is very easy to do. The SQLite database includes the user table, Sqlite_master,sqlite_sequence,sqlite_temp_master. Where Sqlite_master is simply the same as other databases, storing information about all the tables created by the user, the latter's usefulness unknown origin, as the name implies, is to store temporary user tables, and the middle is what we use to set up automatic indexes, storing the current values of all user table automatic IDs. So if you want to make a user table ID starting from 0 or any number, you just need set seq= any number, just like the normal database operation. So my SQL statement writes like this:

Update Set = ' 0 ' where = ' TableName ';

That's all

The SQLite database is emptied and the ID starts at 0