Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
use a select to do an insert?
- Thread starter noober
- Start date
Hi:
Yes, if table1 and table2 have the same structure you can do something like this:
insert into table1 select * from table2
Of course, you can use a where clause on the select or even use a subset of the table structure:
insert into table1(col1, col2, col3) select col1, col2, col3 from table2 where col1 = "something"
Regards,
Ed
Yes, if table1 and table2 have the same structure you can do something like this:
insert into table1 select * from table2
Of course, you can use a where clause on the select or even use a subset of the table structure:
insert into table1(col1, col2, col3) select col1, col2, col3 from table2 where col1 = "something"
Regards,
Ed
- Thread starter
- #3
- Status