Re: [sqlite] Subselects negating benefit of index?

"Damien Elmes" wrote in message news:625e49d20904042027y7c029d0fu2cc3812143225...@mail.gmail.com > I have the following query: > >> explain query plan select id from cards where id in (select cardId >> from cardTags where cardTags.tagId in (246)) order by cards.question >>

[sqlite] Subselects negating benefit of index?

Hi folks, I have the following query: > explain query plan select id from cards where id in (select cardId from > cardTags where cardTags.tagId in (246)) order by cards.question collate nocase order fromdetail 0 0 TABLE cards USING PRIMARY KEY 0 0 TABLE cardTags

Re: [sqlite] Insert mode shows wrong type

On Sat, Apr 04, 2009 at 05:25:38PM +1100, BareFeet scratched on the wall: > Hi Jay, > > Thanks for the reply. > > > Asking SQLite for the insert statement doesn't tell you what the > > type in the database is > > Shouldn't it? In my opinion, no. For one thing, depending on the format of a

Re: [sqlite] multiple row insert

"Justin Lolofie" wrote in message news:bb1c266a0904041639s277ce09cpe960a09e94c4b...@mail.gmail.com > Is there syntax to do multiple row insert? Something like: > > insert into my_table (a,b,c) values ((1,2,3),(4,5,6)); > > The documentation for INSERT seems to imply this is not

[sqlite] multiple row insert

Is there syntax to do multiple row insert? Something like: insert into my_table (a,b,c) values ((1,2,3),(4,5,6)); The documentation for INSERT seems to imply this is not possible. Thanks, Justin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Insert mode shows wrong type

Hi Jay, Thanks for the reply. > Asking SQLite for the insert statement doesn't tell you what the > type in the database is Shouldn't it? It doesn't seem that any output mode in the sqlite3 command will distinguish types. CSV sometimes quotes text, sometimes doesn't. And now it seems