What's the maximum number of arguments allowed within the IN(., ... ,.) function?
With another words, what's the maximum N for such query to be valid
SELECT * FROM mytable WHERE mycol IN (a1, a2, ..., aN);
Asked
Active
Viewed 45 times
1
Haradzieniec
- 9,086
- 31
- 117
- 212
-
1There is not *per se* a maximum, but there might be a maximum query length -- and there might be a better way to write the query without an `IN`. – Gordon Linoff Jan 22 '17 at 17:20