update语句结合case when例子:
根据master_id和class_idx来更新数据
如图:
sql语句:update table_name
set ins_comp_id='111',bxgs_fl_id='111',total_money =
case class_idx when 'JQX' then '900' when 'SYX' then '2300' else null end
where a.master_id='739E4rMaTt2ys6Wum32gqw';