java - How many times does this MySQL query execute? -


in company while looking code, came across query:

update people set approval="a" peopleid in (peoples); 

here peoples string containing 1,2,3,4,5,6 this. contains more 150 names. thought of doing batch update. other team members executes 1 time , improves. have doubt mysql internally executes 150 times. see taking lot of time. searched in net did not find answer. can tell me here query fine or batch update good?


Comments