SQLite Drop Column

来源:互联网 发布:宝鸡软件开发 编辑:程序博客网 时间:2024/05/29 19:37
 
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;

原创粉丝点击