Copy rows from one table to another in MySQL

Question

I have two tables with the same structure. I need to select data from one table and have to store them into the other.

How can I do that?

Answer 1

insert into tablea(id,name) select id,name from tableb;