支持下面这种写法吗?
update tmp set exchangecd='XSHG' if exchangecd='SH' set exchangecd='XSHE' if exchangecd='sz'
不支持,要这么写
UPDATE tmpSET col1 = CASE WHEN col1 = 'SH' THEN 'hello1' WHEN col1 = 'SZ' THEN 'hello2' ELSE col1END;