Is there a limit on the number of rows that I can update using the MySQL query IN clause?

Question

Is there a limit on the number of rows that I can update in a single query using a sentence IN? For instance:

mysql_query("UPDATE `table` SET `row`=1 WHERE `id` IN(1,2,3,4,5,6,7,8....5000)");

Can I update all 5000 lines at once? Or does MySQL have a limit on the number of elements in a sentence IN?

Note: . I want to know if there is an update limit in one query, where MySQL will say something like "the maximum number of entries in the IN section is exceeded". That is, I ask a question about a possible restriction , besides the parameter "maximum packet size" in MySQL.

Answer 1

MySQL IN, , . :

IN max_allowed_packet.

, , , , , a JOIN IN(subquery) WHERE.