Hi,
I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m'
AND hobby_id='3'
AND id IN ( $value );
$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.
It might be about 10,000 id in $value. What is the maximum value
From: Batara Kesuma [EMAIL PROTECTED]
It might be about 10,000 id in $value. What is the maximum value I can
pass in a query? Is this the right way to do it? (I mean, using a very
big value inside IN)
WIth 10,000 items in an IN () condition, my guess is that the list is a
result of another
On 28-Jan-2004 Batara Kesuma wrote:
Hi,
I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m'
AND hobby_id='3'
AND id IN ( $value );
$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.
It might
: Batara Kesuma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 4:00 AM
To: [EMAIL PROTECTED]
Subject: Very big IN ( $value )
Hi,
I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m'
AND hobby_id='3'
AND id IN ( $value