On Mar 11, 5:55 pm, Michael Adams <[email protected]> wrote:
> I want to take all the data from a MySQL query and drop it into another table.

You can do it directly with SQL:

  INSERT INTO table1(col1, col2) SELECT (col1, col2) FROM table2;

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

Malc

-- 
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]

Reply via email to