擅长:python、mysql、java
<p>不要尝试在调用中运行多个语句</p>
<p>一定要使用<code>BEGIN</code>和<code>COMMIT</code></p>
<p>一定要使用<code>FOR UPDATE</code></p>
<p>您需要5个单独的命令:</p>
<pre><code>BEGIN;
SELECT ... FOR UPDATE; to keep other connections from messing with the row(s).
UPDATE ...;
DELETE ...
COMMIT; do all of the above "atomically"
</code></pre>