开发者

how to get primary key column names for a given table?

All I know is only table name, and id value on which I want to perform query, but I do no开发者_Python百科t know what is id called in that table.


You can probably lookup the column name for the primary key column(s) using the answer to a quite similar question..

sqlite> pragma table_info(...)

It should also work programmatically, if needed.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜