求教select into 语句

[Avoid]

table1
a1 a2 a3

table2
id b1 b2 b3

其中table2的id是自增的
要求把table1的所有内容复制到table2的id=null中

[cheny1234]

SELECT table1.* INTO table2 FROM table1

[Avoid]

大哥，我要把a1,a2,a3的值加入到b1,b2,b3中。table2原来有数据
你认为SELECT table1.* INTO table2 FROM table1
能行吗？
不要误导我

[zjcxc]

insert into table2 select * from table1

[cheny1234]

那就试试:
SELECT table1.a1 as b1,table1.a2 as b2 table1.a3 as b3 INTO table2 FROM table1

[liuyann]

insert into table2 (b1,b2,b3)
select a1,a2,a3 from table1