MySQL IN Clause: Maximum arguments

[elppa]

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.

 

[davethewave]

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.

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

 

[elppa]

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

Cheers.

I'm very happy with the schema.

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