On 4/12/05, Thomas Briggs <[EMAIL PROTECTED]> wrote:
>
>Aliases rowid to rowid seems to work for me, i.e.
Aha. I forgot about that trick. Thanks!
Aliases rowid to rowid seems to work for me, i.e.
SELECT rowid as rowid, primary_key_col
-Tom
> -Original Message-
> From: Will Leshner [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 12, 2005 5:36 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] determing
I realize that in sqlite 3, if I construct a query with 'rowid' as one
of the columns, and the table I am querying explicitly declares an
integer primary key column, my results have the table's name for the
column and not 'rowid'. What I'm wondering is if there is a good way
to determine which of
3 matches
Mail list logo