Does anyone know how to modify data in multiple rows and columns in MySql? Please give me some advice.

Question

Which master knows how to modify data in multiple rows and columns in MySql

Answer 1

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.

Answer 2

Look for common conditions and where conditions to perform batch up operations

Answer 3

Deleted and re-inserted (escape...

Answer 4

At least provide your table structure, otherwise how will others see it?

Answer 5

Solved, just use a loop