擅长:python、mysql、java
<p>SQlite没有INSERT-INTO语法。</p>
<p>2019年,我使用<strong>TEMPORARY</strong>关键字创建临时表并将数据插入临时表:</p>
<pre><code>CREATE TEMPORARY TABLE equipments_backup(field1 TEXT, field2 REAL)
INSERT INTO equipments_backup SELECT field1, field2 FROM equipments
</code></pre>