MySQL 批量更新

update crosssortingsystem set
`Value` = CASE `Code` when 'crossSystem' then '12521' else `Value` END,
UpdateTime = CASE `Code` when 'LatticeInfo' then DATE_FORMAT(NOW(),"%y-%m-%d") else UpdateTime END

posted @ 2021-02-05 11:41  剑存古风  阅读(66)  评论(0编辑  收藏  举报