02 2021 档案

MySQL 数据库 批量更新语句
摘要：update crosssortingsystem set `Value` = CASE `Code` when 'LatticeInfo' then '202' else `Value` END,UpdateTime = CASE `Code` when 'LatticeInfo' then DA 阅读全文
posted @ 2021-02-26 13:51 剑存古风 阅读(637) 评论(0) 推荐(0)
MySQL 批量更新
摘要：update crosssortingsystem set `Value` = CASE `Code` when 'crossSystem' then '12521' else `Value` END,UpdateTime = CASE `Code` when 'LatticeInfo' then 阅读全文
posted @ 2021-02-05 11:41 剑存古风 阅读(88) 评论(0) 推荐(0)