"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
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
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
"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
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
5 matches
Mail list logo