BEGIN TRANSACTION; CREATE TEMPORARY TABLE test_backup(a,b); INSERT INTO test_backup SELECT a,b FROM test; DROP TABLE test; CREATE TABLE test(a,b); INSERT INTO test SELECT a,b FROM test_backup; DROP TABLE test_backup; COMMIT;原文链接:https://www.f2er.com/sqlite/202584.html