var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update tbl SET Case When Condition1 THEN Col1=1 When
I want to do a Update operation to set a new value to Col1. the particular value is dependent on some conditions, Condition1 Condition2.....
I tried a query like the following command, but no luck.
I wonder if 'Case When' can only be used in SELECT clauses?
don't forget the WHERE clause
SET Col1 = CASE WHEN Condition1
ELSE 2 END
WHERE Condition1 OR Condition2