P Kishor-3 wrote:
> what is the name of the column? Is it '--idcolumn--'?
That was only example written when I didn't know even for what syntax to
look for. Now problem comes to how to run SELECT against PRAGMA
table_info(tblname).
Only way out of this that I found is to run regex against the
On Mon, May 3, 2010 at 2:14 AM, yogibabu wrote:
>
> like this: SELECT --idcolumn-- FROM `table`
what is the name of the column? Is it '--idcolumn--'? Are the leading
and trailing '--' part of the name? Remember that leading '--' is used
as SQL comments. If that is indeed
On 3 May 2010, at 8:14am, yogibabu wrote:
> like this: SELECT --idcolumn-- FROM `table`
If you always want to use a unique integer to refer to a record, you can ask
for the column called '_rowid_' even if you didn't define one. You can use
this in SELECT and UPDATE commands, as long as you
like this: SELECT --idcolumn-- FROM `table`
--
View this message in context:
http://old.nabble.com/is-it-possible-to-return-primary-key-column-from-given-table---tp28432175p28432175.html
Sent from the SQLite mailing list archive at Nabble.com.
___
4 matches
Mail list logo