Insert into Student(Sno,Sname,Ssex,Sage,sdept)
select '95001','李勇','男','20','CS' union all
select '95002','刘晨','女','19','IS' union all
......
select '96003','李四','男',18,'IS'
详细解决方案
sql脚本批量安插
热度：36 发布时间：2016-05-05 13:38:36.0
Insert into Student(Sno,Sname,Ssex,Sage,sdept)
select '95001','李勇','男','20','CS' union all
select '95002','刘晨','女','19','IS' union all
......
select '96003','李四','男',18,'IS'
相关解决方案