MySQL: How to copy/move values from one table into another?

[bachx]

I have some data in table, and I want to move that data (certain fields only) into another table in the same DB. I'm wondering how can this be done?

[per1os]

$sql = "INSERT INTO table_name (`col1`, `col2`) VALUES(SELECT col1,col2 FROM table_name2 WHERE CONDITION=TRUE);";

 

Something like that may work, not sure.

[bachx]

Negative.

 

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 x1,x2 FROM table1 WHERE CONDITION=TRUE)' at line 1

[per1os]

http://dev.mysql.com/doc/refman/4.1/en/insert-select.html

 

INSERT INTO tbl_temp2 (fld_id)

  SELECT tbl_temp1.fld_order_id

  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

 

$sql = "INSERT INTO table_name (`col1`, `col2`) SELECT col1,col2 FROM table_name2 WHERE CONDITION=TRUE;";

 

 

[bachx]

That did it. Thanks 

[bachx]

Alright. I have another question. I want to do the same exact thing, but instead of inserting new values, I want it to update the current data in the new table. Anyone?

[bachx]

Anyone can answer my last question? I'll be grateful.