List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 6 1999 7:30pm
Subject:Re: how many args to SELECT...IN()
View as plain text  
"Alok K. Dhir" wrote:
> 
> The original question still stands however - what _is_ the limit for
> arguments to the in() function?
> 
> Monty?
> 
< cut >

Hi Joel

The ultimate limit for each query is the max_packet_size variable set on the server.
This is in 3.22.xx set to 1MBytes.
This should be enough for some numbers if not increase it :)

Tschau
Christian

Thread
how many args to SELECT...IN()Joel Bremson6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Thimble Smith6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Joel Bremson6 Aug
    • Problem reading tablesPaul McGovern6 Aug
    • Re: how many args to SELECT...IN()Thimble Smith6 Aug
      • Re: how many args to SELECT...IN()Alok K. Dhir6 Aug
        • Re: how many args to SELECT...IN()Paradox6 Aug
          • Re: how many args to SELECT...IN()Michael Widenius6 Aug
        • Re: how many args to SELECT...IN()Christian Mack6 Aug
  • Re: how many args to SELECT...IN()Scott Hess6 Aug
    • Re: how many args to SELECT...IN()Joel Bremson6 Aug