只知道插入一个元组的方法如

insert
into Student (Sno,sname,ssex,sdept,sage)
values('200215128','陈冬','男','IS','18')；

但如何插入多条记录呢，请帮忙

insert into student(sno,sname,ssex,sdept,sage) select fields from table
or
insert into student(sno,sname,ssex,sdept,sage)
select '200215128','陈冬','男','IS','18'
union all
select '200215129','陈冬','男','IS','18'
......

[此贴子已经被作者于2007-10-11 9:43:07编辑过]

谢谢 谢谢
但能否再详细点

insert into table1 (f1,f2,f3,f4)
select f1,f2,f3,f4 from table2 where f5 > 0

insert into Student (Sno,sname,ssex,sdept,sage)
select '200215128','陈冬','男','IS','18' union all
select '200215128','陈冬','男','IS','18' union all
select '200215128','陈冬','男','IS','18' union all
select '200215128','陈冬','男','IS','18' union all
select '200215128','陈冬','男','IS','18' union all
select '200215128','陈冬','男','IS','18'

当然插入的每个值是不同的,你改吧!!!

呵呵 够详细的了...