populate table from one to another

Question

I would like to copy data from an existing table say table1 to a new table table2. The tables' engines are different. I mean, the existing table uses MyISAM and the new one uses Innodb.

Answer 1

INSERT INTO newtable SELECT * FROM oldtable;

INSERT SELECT

Answer 2

insert into NewTable (col1, col2, col3) select col1, col2, col3 from OldTable

Answer 3

Look at this http://forums.mysql.com/read.php?21,26193,190902#msg-190902

Answer 4

Another MyISAM to InnoDB article. http://www.linux.com/archive/feed/46370