[求助]请问插入多行的语句？

insert into table1 select * from table2
table1和table2字段名字一样.

insert into table1(fields1, fields2) select fields1,fields2 from table2