17 Oct
2014
17 Oct
'14
9:45 a.m.
CASE/WHEN syntax would be useful for UPDATE/SET clauses. Example: UPDATE tbl1 SET col1 = CASE WHEN ... THEN ... ELSE ... END ; I am not sure if this is conform to ANSI SQL. I would find it useful. Today I have to write multiple UPDATE queries with different WHERE conditions.