一条基础的sql语句
我有两个表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
