擅长:python、mysql、java
<p>您可以通过使用INSERT INTO table SELECT来使用单个执行来简化问题</p>
<p>例如,SQL可以是:-</p>
<pre><code>INSERT INTO today (Title,Description,URL,IMGLink,Score) SELECT Title, Description, URL, IMGLink, Score FROM main ORDER BY Score DESC;
</code></pre>
<p>虽然您可能希望获得结果(受影响的行数,即插入),但您不需要游标。你知道吗</p>
<p>您不妨看看:</p>
<p><a href="https://www.sqlite.org/lang_insert.html" rel="nofollow noreferrer">SQL As Understood By SQLite - INSERT - 2. INSERT INTO table SELECT ...;</a></p>