CopyPastor

Detecting plagiarism made easy.

Score: 1; Reported for: String similarity Open both answers

Possible Plagiarism

Plagiarized on 2018-12-17
by DKV

Original Post

Original - Posted on 2012-02-19
by Stephen Woods



            
Present in both answers; Present only in the new answer; Present only in the old answer;

The way SQLite works an autoincrementing ID will be consistent after rows are deleted (e.g if you delete row id 2, row id 1 and 3 will keep the same value), so the only ways of making the IDs sequential again is to move entries manually around or copy the rows, drop the table, create a new one and inserting the rows again.
If you're using the local storage just for a view, however, you could always use the limit clause to get a select portion of your db for viewing.
The way SQLite works an autoincrementing ID will be consistent after rows are deleted (e.g if you delete row id 2, row id 1 and 3 will keep the same value), so the only ways of making the IDs sequential again is to move entries manually around or copy the rows, drop the table, create a new one and inserting the rows again.
If you're using the local storage just for a view, however, you could always use the limit clause to get a select portion of your db for viewing.

        
Present in both answers; Present only in the new answer; Present only in the old answer;