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)
,下面我们就来说一说关于php查询到某个字段的值用数组表示?我们一起去了解并探讨一下这个问题吧!
php查询到某个字段的值用数组表示
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)