学生表值插入.sql

来自「用SQL实现的一个教务管理系统」· SQL 代码 · 共 84 行

insert
into Student
values('100100001','李虎','男','19850123','武汉',' ','0114051')
insert
into Student
values('100100002','张亮','男','19860909','武汉',' ','0114051')
insert
into Student
values('100100003','李虎','男','19781010','武汉',' ','0114051')
insert
into Student
values('100100004','丁毅','男','19860101','武汉',' ','0114051')
insert
into Student
values('100100005','张亮','男','19851212','武汉',' ','0114051')
insert
into Student
values('100100006','李虎','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100007','刘芳','女','19850908','武汉',' ','0114051')
insert
into Student
values('100100008','王华','女','19850908','武汉',' ','0114051')
insert
into Student
values('100100009','贺虎','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100010','高扬','女','19870907','武汉',' ','0114051')
insert
into Student
values('100100011','卫青','男','19870807','武汉',' ','0114051')
insert
into Student
values('100100012','魏青','女','19851228','武汉',' ','0114051')
insert
into Student
values('100100013','张国庆','男','19861001','武汉',' ','0114051')
insert
into Student
values('100100014','饶伟','男','19850908','武汉','  ','0114051')
insert
into Student
values('100100015','邱明','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100016','袁非','女','19850908','武汉',' ','0114051')
insert
into Student
values('100100017','刘亚','女','19850908','武汉',' ','0114051')
insert
into Student
values('100100018','刘青','女','19850908','武汉',' ','0114051')
insert
into Student
values('100100019','李冉','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100020','石浩','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100021','叶俊','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100022','王国庆','男','19861001','武汉',' ','0114051')
insert
into Student
values('100100023','张建','男','19850908','武汉',' ','0114051')
insert
into Student
values('100100024','张亮','男','19850908','武汉',' ','0114051')
insert
into Student
values('1001000215','刘明','男','19860408','武汉',' ','0114051')
insert
into Student
values('100100026','胡惟','男','19850528','武汉',' ','0114051')
insert
into Student
values('100100027','张亮','男','19850508','武汉',' ','0114051')
insert
into Student
values('100100028','李默','女','19850708','武汉',' ','0114051')