Fill a table from one to another

Question

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

Answer 1

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

Answer 2

INSERT INTO newtable SELECT * FROM oldtable;

INSERT SELECT