使用PHP中的一个mysqli_query调用更新多个MySQL记录

Question

I have to update hundreds of records at once and I'm wondering if it's possible to use one mysqli_query call to update all of them. I know it isn't possible to use something like:

UPDATE table SET col=value1,col=value2,col=value3 WHERE id IN (1,2,3)

Is it possible to somehow use custom functions or another method to update multiple records at once?

Answer 1

use mysqli_multi_query() function, by which you can concat all the queries and pass it the mysqli_multi_query function