Which master knows how to modify data in multiple rows and columns in MySql
PHP中文网2017-06-06 09:53:59
I don’t know the table structure, so I can’t provide a targeted solution, but one method is stored procedures, but one disadvantage is that it affects the performance of mysql. When the number of operations is not particularly large, the impact is not big, but when the operations are very frequent, There may be an impact.
ringa_lee2017-06-06 09:53:59
Look for common conditions and where conditions to perform batch up operations
PHPz2017-06-06 09:53:59
At least provide your table structure, otherwise how will others see it?
