INSERT INTO table SELECT * FROM table
Posted: Fri Jan 21, 2005 7:12 am
I want to run a query in the form
INSERT INTO table SELECT * FROM table
which i can do with no problems.
The problem i do i have is the data pulled in the select area needs to bbe changed slightly before inserting.
I Want to pull out the info, change 2 entries and then insert into another table. Is there a way to do this without building a table of results and then reinserting each one in the form INSERT INTO table (field1,field2,field3) VALUES (entry1,entry2,entry3) ?
If i did it this way then the query would have to be changed each time the table structure changed.
INSERT INTO table SELECT * FROM table
which i can do with no problems.
The problem i do i have is the data pulled in the select area needs to bbe changed slightly before inserting.
I Want to pull out the info, change 2 entries and then insert into another table. Is there a way to do this without building a table of results and then reinserting each one in the form INSERT INTO table (field1,field2,field3) VALUES (entry1,entry2,entry3) ?
If i did it this way then the query would have to be changed each time the table structure changed.