Copy rows from one table to another in MySQL

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

Since they are the same structure then you can just do

insert into table1 select colum1, column2,... from table2

leave out the values keyword

insert into tbl1 
select * from tbl2