[EMAIL PROTECTED]
Date: Sunday, September 2, 2007 1:03 am
Subject: Re: [sqlite] Difference between OR and IN
[http://www.sqlite.org/php2004/page-052.html]
On 9/1/07, RaghavendraK 70574 [EMAIL PROTECTED] wrote:
I want to know why
prepareStatement: select * from xxx where IN (?);
stmt.bind
it!
*
- Original Message -
From: Trevor Talbot [EMAIL PROTECTED]
Date: Sunday, September 2, 2007 1:03 am
Subject: Re: [sqlite] Difference between OR and IN
[http://www.sqlite.org/php2004/page-052.html]
On 9/1/07, RaghavendraK 70574 [EMAIL PROTECTED] wrote
PROTECTED]
Date: Sunday, September 2, 2007 8:15 pm
Subject: Re: [sqlite] Difference between OR and IN
[http://www.sqlite.org/php2004/page-052.html]
Once you get your first row back (corresponding to (a==1), simply
halt
there and sqlite3_finalize() or sqlite3_reset the statement. You
control
On 9/2/07, RaghavendraK 70574 [EMAIL PROTECTED] wrote:
select * from test where column in
('98451234','9845123','984512','98451',
'9845','984','98','9','-1') limit 1;
even when limit 1 is provided it continues to search.
Continues to search in what way? What exactly are you looking at?
On 3/09/2007 1:00 AM, RaghavendraK 70574 wrote:
Hi,
create table test (column text);
Please try pasting in SQL that actually runs. column is a reserved word.
create index idx on text(column);[IN uses index]
Please try pasting in SQL that actually runs. You need test, not
text. Use -- for
it!
*
- Original Message -
From: Dan Kennedy [EMAIL PROTECTED]
Date: Saturday, September 1, 2007 11:59 am
Subject: Re: [sqlite] Difference between OR and IN
[http://www.sqlite.org/php2004/page-052.html]
On Sat, 2007-09-01 at 11:58 +0800, RaghavendraK
On 9/1/07, RaghavendraK 70574 [EMAIL PROTECTED] wrote:
I want to know why
prepareStatement: select * from xxx where IN (?);
stmt.bind(abc,xyz,123); is not supported for multiple
values.
It's not supported because it doesn't make sense. The parametric
binding mechanism is for single values;
immediately and
delete it!
*
- Original Message -
From: Trevor Talbot [EMAIL PROTECTED]
Date: Sunday, September 2, 2007 1:03 am
Subject: Re: [sqlite] Difference between OR and IN
[http://www.sqlite.org
Hi,
In one of the slides http://www.sqlite.org/php2004/page-052.html;
it is stated#65292; OR will make DBEngine not to use Indexes and IN will
make DBEngine use
indexes
I could not understand the rationale abt this. Can u explain?
regards
ragha
On Sat, 2007-09-01 at 11:58 +0800, RaghavendraK 70574 wrote:
Hi,
In one of the slides http://www.sqlite.org/php2004/page-052.html;
it is stated#65292; OR will make DBEngine not to use Indexes and IN will
make DBEngine use
indexes
I could not understand the rationale abt this. Can u
10 matches
Mail list logo
