1. INSERT INTO FROM 语句
insert into tablebackup select * from table;
insert into tablebackup select field1,field2,field3 from table where ...;
前提：tablebackup 必须存在2. SELECT INTO FROM 语句
select * into tablebackup from table;
select field1,field2,field3 into tablebackup from table;