ROWIDs

Page 24 of 41
[prev] [next]

Specifying the rowid on an INSERT:

CREATE TABLE table2(x);
INSERT INTO table2(rowid, x) VALUES(123,'hi');

Changing the value of the rowid:

UPDATE table2 SET rowid=rowid-1 WHERE rowid=123;

Inserting NULL into ROWID fills it in with the next available integer, or a random integer if the largest integer is already taken

Use the last_insert_rowid method to get the ROWID that was used for the most recent insert