开发者

How to retrieve row from Sqlite3

开发者 https://www.devze.com 2023-03-31 14:00 出处:网络
How to retrie开发者_高级运维ve row from sqlite3 from table when I have rowid meta data(sqlite globalval)from sqlite3 ? The ROWID in SQLite is an alias for the \"INTEGER PRIMARY KEY\".

How to retrie开发者_高级运维ve row from sqlite3 from table when I have rowid meta data(sqlite global val)from sqlite3 ?


The ROWID in SQLite is an alias for the "INTEGER PRIMARY KEY".

       select * from myTable where foo = {the rowid value in question}

       (where foo is the name you have given to the integer primary key column in the CREATE TABLE statement)
0

精彩评论

暂无评论...
验证码 换一张
取 消