Moving records from 1 table to another 1

[ArtWerk]

Is there and easy SQL syntax to move or copy rows from 1 table to another?

I'm creating a temporary table and after matching duplicates, and deleting the duplicate rows, i want to move or copy the remaining rows into the permanent table.

 

[TonyGroves]

Sure:
[tt]
INSERT tbl2 SELECT * FROM tbl1 WHERE ...
[/tt]

 

[ArtWerk]

ok, i'm having trouble with this just a bit.

I have existing data in a table called "pcp".

The columns will be outputted into a variable: $newcols (using PHP)

The columns i want to move the data from is in a table called: "temp"

Those columns are found with the variable: $newheaders

The SQL statement i'm using is:

INSERT INTO `".$list."` (".$newcols.") VALUES (SELECT ".$newheaders." FROM `temp`);

which results into something like:

INSERT INTO `pcp` (prov_id, phone, address2, city, state, county, primary_addr, max_panel, region, capacity, spec_id, spec_desc, languages) VALUES (SELECT prov_id, phone, address2, city, state, county, primary_addr, max_panel, region, capacity, spec_id, spec_desc, languages FROM `temp`);

Not exactly sure what i'm doing wrong, but it's not working right... I get an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT prov_id, phone, address2, city, state, county, primary_addr, max_panel, r' at line 1

 

[TonyGroves]

The syntax I provided should work. Instead of the *, you can list field names. Example:
[tt]
INSERT pcp
SELECT prov_id,phone,address2, ...
FROM temp
[/tt]

 

[TonyGroves]

Sorry, I meant:
[tt]
INSERT pcp (prov_id,phone,address2, ...)
SELECT prov_id,phone,address2, ...
FROM temp
[/tt]

 

[ArtWerk]

That worked perfect! Thank you so much!