Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
According to the documentation for the MySQL IN function: The number of values in the IN() list is only limited by the max_allowed_packet value. The default value for it is 67108864. So, you...
Answer
#1: Initial revision
by
Alexei
·
2020-11-13T18:59:21Z (about 4 years ago)
According to [the documentation for the MySQL IN function](https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#function_in): > The number of values in the IN() list is only limited by the max_allowed_packet value. The default value for it is [67108864](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_allowed_packet). So, you should be able to squeeze quite a big number of identifiers, but you should definitely try it out to see how it behaves under a normal server load. I am not sure how MySQL sees such queries though (I only have experience with such queries in MSSQL where it can [complain that they are too complex](https://stackoverflow.com/a/21179253/2780791)).