How to delete all of data by SQLiteDatabase in Android

my_table(ID INTEGER PRIMARY KEY AUTOINCREMENT, Name NVARCHAR(100)) I deleted all of the data in SQLiteDatabase by the command "DELETE FROM my_table". It's was a success, but I have one trouble: When I insert new data into my_table, ID auto-increment with the old ID, It means have field memory is existing in my program. Can you help me solve it? Thank everybody enter image description here

https://stackoverflow.com/questions/66881156/how-to-delete-all-of-data-by-sqlitedatabase-in-android March 31, 2021 at 11:14AM