擅长:python、mysql、java
<p>在您的示例中,它们是5个学生ID,只有4个分数需要更新。</p>
<p>如果要更新的学生列表不长,则可以在一个查询中进行更新,如下所示:</p>
<pre><code>UPDATE t_student
SET studentScore = CASE
WHEN studentID=1 THEN 12.76
WHEN studentID=123 THEN 73.2
WHEN studentID=33 THEN 83.893
WHEN studentID=5524 THEN 92.3
ELSE studentScore END
WHERE studentID IN (1, 123, 33, 5524, 425653)
</code></pre>
<p>尽管如此,使用包含以下几个查询的SQL语句的可能性较小:</p>
<pre><code>UPDATE t_student SET studentScore = 12.76 WHERE studentID = 1;
UPDATE t_student SET studentScore = 73.2 WHERE studentID = 123;
UPDATE t_student SET studentScore = 83.893 WHERE studentID = 33;
UPDATE t_student SET studentScore = 92.3 WHERE studentID = 5524;
</code></pre>