SQL Select INTO Statement

The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.

Syntax SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source

SELECT * INTO tbl3Backup FROM tbl3;

select * from tbl3Backup;

select * from tbl3;

drop table tbl3Backup;

SELECT * INTO tbl3Backup FROM tbl3 where m1>10;

select * from tbl3;

drop table tbl3Backup;

SELECT sno,m1,m2 INTO tbl3Backup FROM tbl3;

select * from tbl3Backup;

drop table tbl3Backup;

SELECT t1.Fname,t1.age,t2.address INTO tbl3Backup FROM tbl1 AS t1,tbl2 AS t2 WHERE t1.Fname=t2.Fname;/*we use all type JOIN*/

select * from tbl3Backup;