我有两个表test1，test2里面的字段完全相同，我想把test1里的内容写到test2表里，下面是我的sql语句
insert into test2 values(select * from test1)但是报错
请问该如何写呢
谢谢
------解决方案--------------------
insert into test2 select * from test1
------解决方案--------------------
insert into test2
select * from test1
------解决方案--------------------
insert into test2 select * from test1
select /values 重复
------解决方案--------------------
select * into test2 from test1