1. 先創(chuàng)建一個一樣的表
2. insert into sample: BEGIN TRANSACTION; CREATE TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; COMMIT; 參考 http:///faq.html (11) =========2012.Dec.12=========== CREATE TABLE t1_backup AS SELECT * FROM t1; |
|