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
Post a Comment