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
I have a PHP program that does a SELECT and then updates some of the values based on an algorithm. Rather than updating one row at a time UPDATE example_table SET COLUMN_A = 1 WHERE primary_k...
Question
mysql
#2: Post edited
by
Charlie Brumbaugh
·
2020-11-12T22:51:12Z (about 4 years ago)
#1: Initial revision
by
Charlie Brumbaugh
·
2020-11-12T22:47:44Z (about 4 years ago)
In MySQL is there a limit to the number of keys in a IN() statement?
I have a PHP program that does a SELECT and then updates some of the values based on an algorithm. Rather than updating one row at a time ``` UPDATE example_table SET COLUMN_A = 1 WHERE primary_key_column = 10; ``` I was thinking of doing many updates at once like ``` UPDATE example_table SET COLUMN_A = 1 WHERE primary_key_column IN(1,2,3,4,5); ``` The SELECTS are pulling in 100,000 rows at a time and to start with every single one of them may need to be updated, **am I going to run into a limit of values in the IN() clause?**