--1.最原始的方法,一条一条的插入
insert into Student
values( 95001,'李勇','男',20,'CS' )
insert into Student
values( 95002,'刘晨','女',19,'IS' )
--2.
insert into Student
select 95001,'李勇','男',20,'CS' union all
select 95002,'刘晨','女',19,'IS' union all
select 95003,'王敏','女',18,'IS' union all
select 95004,'张立','男',19,'MA' union all
select 96001,'徐一','男',20,'IS' union all
select 96002,'张三','女',21,'CS' union all
select 96003,'李四','男',18,'IS'
--注意:此处最后一行没有,如果也加上这一句,那结果会是先插入这些数据,再把原来存在的数据也再插入一遍(没有设置主键的情况下);如果有主键,会报错,说不满足主键约束