Suppose I have a table in SQLite and I have added to it 3 rows. Suppose now I want to add a new row, but instead of it being "appended" to the previous three (which is what would happen if I just call INSERT INTO
), I want that new entry to be placed between the current row 1 and row 2 (for reasons of my own).
Is it possible? I couldn't find such a feature being mentioned in the tutorials I had a look.
And is it also possible to "update" directly an already existing row in changing the position in the table where it is placed? (by "directly" I mean a command that do this once instead of first deleting the current row and then inserting it again in the desired place using the method which would be the answer to the first question).
Aucun commentaire:
Enregistrer un commentaire