How Copy rows from one table to another table?

Question

I have 2 table with same struture i need to select data from one table and have to store in to 2nd table.

Answer 1

leave out the values keyword

insert into tbl1 
select * from tbl2

Answer 2

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

Answer 3

Since they are the same structure then you can just do

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