擅长:python、mysql、java
<p>尝试将两个列表放入临时表(studentID,studentScore)。</p>
<p>然后您应该能够运行一个查询来相应地更新主表。</p>
<pre><code>UPDATE studentTable t1
JOIN tempTable t2 ON t1.studentID = t2.studentID
SET t1.studentScore = t2.studentScore WHERE t2.studentScore > t1.studentScore
</code></pre>