SQLite Drop Column

概述  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;

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;

总结

以上是内存溢出为你收集整理的SQLite Drop Column全部内容，希望文章能够帮你解决SQLite Drop Column所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。