Re: [sqlite] Subselects negating benefit of index?

2009-04-04 Thread Igor Tandetnik
"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 >> collate nocase > order

[sqlite] Subselects negating benefit of index?

2009-04-04 Thread Damien Elmes
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 WIT

Re: [sqlite] Insert mode shows wrong type

2009-04-04 Thread Jay A. Kreibich
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

2009-04-04 Thread Igor Tandetnik
"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 possible. Well, yo

[sqlite] multiple row insert

2009-04-04 Thread Justin Lolofie
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 htt