query to copy the records from existing table to new table

**davef** · Sep 24 '07, 02:51 PM

Originally posted by doll

hi all
i need to write a query to copy the records from existing table to new table...my existing table name is persons and the fields are name, salary,id,age.. i need to copy these to another table called t1..wat is the query..please help

thanking you

Code:

insert into t1 (name,salary,id,age) select name,salary,id,age from persons

query to copy the records from existing table to new table

query to copy the records from existing table to new table

Comment