如何插入多条记录?

[xucl]

如何在数据表中一次插入多条记录?清赐教!!! :)

[yujohny]

create table table2(a int,b int)

insert into table2(a,b)
select 1,2
union select 2,3
union select 3,4

[yujohny]

insert into table2(a,b)
select col1,col2 from table1 where ....

[welyngj]

使用导入导出向导。

[gmlxf]

insert yourtable
select 1,2,3..
union all 2,3,4...
union all 5,3,4...

select col1,col2... into newtable from oldtable where ....

[hjb111]

insert into yourtable(col1,col2,...) values (val1,valu...)
insert into yourtable(col1,col2,...) values (val1,val2...)
insert into yourtable(col1,col2,...) values (val1,val2...)
insert into yourtable(col1,col2,...) values (val1,val2...)
insert into yourtable(col1,col2,...) values (val1,val2...)
...

一次执行不就行了！

[pengdali]

insert into table2(a,b)
select 1,2
union all select 2,3
union all select 3,4

光union 是会去除重复的。