MySQL IN Clause: Maximum arguments

Discussion in 'Web Design and Development' started by elppa, Feb 12, 2009.

  1. elppa macrumors 68040

    elppa

    Joined:
    Nov 26, 2003
    #1
    What's the maximum number of arguments you can use in a MySQL IN clause?

    Or is there no predefined limit?

    Yes I have tried searching the manual and Google and no I can't find the answer.
     
  2. davethewave macrumors member

    Joined:
    Jul 30, 2007
    Location:
    Trieste, Italy
    #2
    appearentely there is no limit.
    but again, if you have such a big number of arguments, it is better to look on a sql statement / sql schema rewrite.
    bye DV
     
  3. elppa thread starter macrumors 68040

    elppa

    Joined:
    Nov 26, 2003
    #3
    Cheers.

    I'm very happy with the schema.

    There won't be many, just don't want it cutting out after 10
     

Share This Page