mysql 批量更新10000+的数据，有什么效率比较高的方法

Answer 1

If the data is regular, my idea is to cut the table, then replace and merge, instead of updating directly, which is slow. If there is no pattern in the data, there is no particularly good method in mysql for such a large amount