update wave_good_detail
SET pk_goods_class = case
WHEN pk_wave=11 and goods_code = 1 THEN pk_goods_class -100
WHEN pk_wave=22 and goods_code = 22 THEN pk_goods_class -19
else 1000 end ,
warehouse_name = case
WHEN pk_wave=11 and goods_code = 1 THEN "拼命努力"
WHEN pk_wave=22 and goods_code = 22 THEN "无怨无悔"
else "人生虚幻" end ,
pk_warehouse=10000
where pk_wave_good_detail in (1,2,3,4)