dongwuwu6104
dongwuwu6104
2014-10-17 11:19

Mysql INSERT ... ON DUPLICATE KEY UPDATE响应

已采纳

Hello I have a table A and I want when a new value (not UPDATE) is inserted in that table to do an INSERT in table B, I tried to play with the responce of the $query INSERT INTO .. ON DUPLICATE KEY UPDATE but no luck, it always returns 1.

$query = "INSERT INTO table ".$fields." VALUES ".$values." ON DUPLICATE KEY UPDATE updated=1"
$response = $dbc->query($query);
if($response == 1)

I have also tried a 'hack' lets say, putting the UPDATE above the INSERT so if the entry doesnt exist to fail but that again returns 1 everytime.

 $query = "UPDATE table SET updated=1 ..;
 $response = $dbc->query($query);
 if($response == 1)
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • dongtan1009 dongtan1009 7年前

    Thanks @boomoto for helping me figuring out the answer:

     $query = "UPDATE tableA ..
     $response = $dbc->query($query);
     if(mysqli_affected_rows($dbc)==0){
            $query2 = "INSERT INTO tableB ..
            $response2 = $dbc->query($query2);
    
            $query = "INSERT INTO tableA ..
            $response = $dbc->query($query);
        }   
     }
    
    点赞 评论 复制链接分享
  • duangang4001 duangang4001 7年前

    This should work:

    <?php
    $link = mysqli_connect("localhost", "my_user", "my_password", "world");
    mysqli_query($link, "INSERT INTO tableA ".$fields." VALUES ".$values." ON DUPLICATE KEY UPDATE updated=1");
    
    if(mysqli_affected_rows($link)==1)
    {
       mysqli_query($link, "INSERT INTO tableB ".$fields." VALUES ".$values.");
    }
    ?>
    
    点赞 评论 复制链接分享

为你推荐