vendredi 19 juin 2015

Search missing rowId in sqlite

In my table there are rows that have been deleted. How can I find the first missing id?

Ex:

ID    DATA
1    row1
2    row2
4    row3
8    row4

How can I find that Id 3 is missing?

Aucun commentaire:

Enregistrer un commentaire