INSERT to a table by SELECT

INSERT INTO Target_Table (col1, col2, col3)
SELECT col1,col2,col3
FROM Source_Table

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