How to transfer data from one table to another with different structure

So, I have two MySQL tables "new_table" and "old_table", what I would like to know is how can I transfer all the data I have in my old table to my new table

The two tables share the same structure up to first 15 columns, but the new table also has additional 10 more columns which the old table doesnt have.

Is there any way I can do this without manually copying the data, which I have been doing for all this time?

 

Use INSERT INTO....SELECT e.g.

INSERT INTO new_table (column1, column2, column3)
SELECT col1, col2, col3 FROM old_table

Code (markup):

 

Great, thanks mwasif! Rep +

 

You are welcome