Java优学网MySQL更新数据教程：轻松掌握UPDATE语句，高效修改数据库记录

UPDATE 表名 SET 列名1=新值1, 列名2=新值2 WHERE 条件;

UPDATE products SET price = CASE

WHEN product_id = 1001 THEN 299
WHEN product_id = 1002 THEN 399  
WHEN product_id = 1003 THEN 599
ELSE price

END WHERE product_id IN (1001, 1002, 1003);