mysql更新注意_mysql 更新状态 注意放到最后

UPDATE zanbao.t_order

SET

step = CASE stat

WHEN '2' THEN '1'

WHEN '4' THEN '2'

END,

sh_person = CASE stat

WHEN '4' THEN '100006'

ELSE sh_person

END,

sh_date = CASE stat

WHEN '4' THEN NOW()

ELSE sh_date

END,

sh_remarks = CASE stat

WHEN '4' THEN ''

ELSE sh_remarks

END,

qr_person = CASE stat

WHEN '2' THEN '100006'

ELSE qr_person

END,

qr_date = CASE stat

WHEN '2' THEN NOW()

ELSE qr_date

END,

qr_remarks = CASE stat

WHEN '2' THEN ''

ELSE qr_remarks

END,

stat = CASE stat

WHEN '2' THEN '3'

WHEN '4' THEN '5'

END

WHERE

stat IN ('2' , '4')

AND id = 'D201504090033'