有没有一种方法可以不逐行更新，而在表MySQL上更新得更快？

UPDATE your_table
SET column_name = CASE id
    WHEN 1 THEN 'new_value_1'
    WHEN 2 THEN 'new_value_2'
    -- 更多情况...
END
WHERE id IN (1, 2, ...);

UPDATE your_table t1
JOIN another_table t2 ON t1.id = t2.id
SET t1.column_name = t2.new_value;

CREATE TEMPORARY TABLE temp_table AS
SELECT id, new_value FROM your_table WHERE condition;

UPDATE your_table t1
JOIN temp_table t2 ON t1.id = t2.id
SET t1.column_name = t2.new_value;

REPLACE INTO your_table (id, column_name) VALUES (1, 'new_value_1'), (2, 'new_value_2');

INSERT INTO your_table (id, column_name) VALUES (1, 'new_value_1'), (2, 'new_value_2')
ON DUPLICATE KEY UPDATE column_name = VALUES(column_name);