批量insert数据

insert into student(sno,sname,ssex,sage,sdept)  select  '95001','李勇','男','20','cs'
union  select '95002','刘晨','女','19','is'
union select '95003','王敏','女','18','ma'
union select  '95004','张立','男','19','is' 
posted on 2005-11-22 19:09  David  阅读(913)  评论(0编辑  收藏  举报