条件多个不同时如何更新单个表？

问题描述：

I want to update the table.I have two update query but I want to use it in a single update query.Column name and Where condition are different in both queries.Would you help me in this?

   $sql="UPDATE points SET hero='$total_hero'+'$points' WHERE user_id='$hero_id'"; 
   $sql="UPDATE points SET zero='$total_zero'+'$points' WHERE user_id='$zero_id'";

我想更新表。我有两个更新查询，但我想在单个更新查询中使用它。列名和Where条件在两个查询中都不同。你能帮我吗？ p>

  $ sql =“UPDATE points SET hero ='$ total_hero'+'$ points'  WHERE user_id ='$ hero_id'“;  
 $ sql =“UPDATE points SET zero ='$ total_zero'+'$ points'WHERERE user_id ='$ zero_id'”; 
  code>  pre> 
  div>

答

You can make use of the below query

$sql="UPDATE points 
      SET hero= CASE WHEN user_id='$hero_id' THEN '$total_hero'+'$points' ELSE hero END, 
      zero= CASE WHEN user_id='$zero_id' THEN '$total_zero'+'$points' ELSE zero END 
      WHERE user_id='$hero_id' OR user_id='$zero_id'";

Hope this would help you out.

条件多个不同时如何更新单个表？

相关推荐