使用sql执行更新或插入操作 - doing an update or an insert with sql

doing an update or an insert with sql

我有一个梦幻高尔夫网站。我使用php读取xml文件并使用以下

更新sql数据库

foreach($field->field->children() as $player){
    $lastname = ($player['last_name']);
    $firstname = ($player['first_name']);
    $firstname = mysql_real_escape_string($firstname); 
    $lastname = mysql_real_escape_string($lastname);  
    $sSQL = "UPDATE `Sheet1` Set InField= 1 WHERE LastName = '$lastname' AND Firstname = '$firstname'";
    $result = mysql_query($sSQL, $conn) or die(mysql_error());

用xml文件上的球员更新数据库INFIELD列。我的问题是，如果他已经不在数据库中，我该如何将该球员添加到数据库中?如果不在数据库中，插入新记录?

确保您在(LastName, FirstName)上有一个唯一的键，然后使用:

INSERT INTO Sheet1 (LastName, FirstName, InField)
VALUES ('$lastname', '$firstname', 1)
ON DUPLICATE KEY UPDATE InField = 1

文档

我建议你调整一下。

player =mysql_query(select player_in_table from players_table where player_in_table = playerx)
if(mysql_num_row(player) = 1){
 //update
} else {
 //update
}