UPDATE语句结合CASE表达式来实现批量更新。，，``sql，UPDATE table_name SET column_name = CASE， WHEN condition1 THEN value1， WHEN condition2 THEN value2， ...， ELSE default_value，END;，``UPDATE语句结合CASE表达式来实现批量更新。，，``sql，UPDATE table_name SET column_name = CASE， WHEN condition1 THEN value1， WHEN condition2 THEN value2， ...， ELSE default_value，END;，``Powered By Z-BlogPHP 1.7.3