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查询到某个字段的值用数组表示(PHPsql根据字段的字去修改不同的值)

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)

,