SQLite two rowid's created when I explicitly creat one
I have a sqlite table that I need to keep the id's from changing when I
VACUUM the database. The documentation says that VACUUM will not change
the rowid's of a table that has an explicit INTEGER PRIMARY KEY.
So, I created a table with
CREATE TABLE tableName (
"rowid" INTEGER PRIMARY KEY,
"updated" DATETIME DEFAULT (CURRENT_TIMESTAMP),
"description" TEXT
)
But that makes a table with two rowid columns. In SQLite Manager add-on
for fireFox I see both, and when I try to access the result set in java it
says "ambiguous column: 'rowid'". Is there a way to explicitly create
rowid or do I have to use a different name? Thanks
No comments:
Post a Comment