List:General Discussion« Previous MessageNext Message »
From:Tom Crimmins Date:February 17 2005 3:07am
Subject:RE: What is the max length of IN() function?
View as plain text  
> -----Original Message-----
> From: Daevid Vincent
> Sent: Wednesday, February 16, 2005 20:59
> To: mysql@stripped
> Subject: What is the max length of IN() function?
> 
> I tried to find this function on the dev.mysql.com site, but good luck
> finding "in"... ;-)
> 
> Can someone tell me what the maximum length is for this function?
> 
> SELECT * FROM foo WHERE bar IN(1,2,3,4,..... N);
> 
> How many entries can there be in between 1 and N ? Hundreds? 
> Thousands?
> Millions?

From http://dev.mysql.com/doc/mysql/en/comparison-operators.html, "The
number of values in the IN list is only limited by the max_allowed_packet
value."

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
Thread
What is the max length of IN() function?Daevid Vincent17 Feb
RE: What is the max length of IN() function?Tom Crimmins17 Feb
  • RE: What is the max length of IN() function?Donny Simonton17 Feb
    • Re: What is the max length of IN() function?Keith Ivey17 Feb