PHP sql 根据字段的字去修改不同的值

update cs set l_pv = case uid  when 1 then l_pv+'10' when 2 then l_pv+'10' when 3 then l_pv+'10' when 4 then l_pv+'10' when 5 then l_pv+'10' else l_pv  end  ,r_pv = case uid  when 2 then r_pv+'5' when 4 then r_pv+'5' else r_pv end  where uid in (1,2,3,4,5)  
发表评论
留言与评论(共有 0 条评论) “”
   
验证码:

相关文章

推荐文章