在MySQL中获取更新的值，而不是受影响的行

您可以使用更新后的存储过程来执行此操作，然后将新值选择到输出参数中。以下返回

new_score

DELIMITER $$   -- Change DELIMITER in order to use ; withn the procedureCREATE PROCEDURE increment_score(   IN id_in INT)BEGIN    UPDATe item SET score = score + 1 WHERe id = id_in;    SELECT score AS new_score FROM item WHERe id = id_in;END$$ -- Finish CREATE PROCEDURE statementDELIMITER ;   -- Reset DELIMITER to standard ;

在PHP中：

$result = mysql_query("CALL increment_score($id)");$row = mysql_fetch_array($result);echo $row['new_score'];