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
最新推荐文章于 2021-05-28 00:36:14 发布