UPDATE product_config
SET
param_value = CASE param_value
WHEN '旧参数1' THEN '新参数1'
WHEN '旧参数2' THEN '新参数2'
END
WHERE param_key = '条件参数';
mysql批量修改
最新推荐文章于 2024-04-30 11:52:35 发布
UPDATE product_config
SET
param_value = CASE param_value
WHEN '旧参数1' THEN '新参数1'
WHEN '旧参数2' THEN '新参数2'
END
WHERE param_key = '条件参数';