3insert info.sql

一个教学管理系统,可以满足一般课程设计的要求

use scdb
insert into lesson
values('01','英语','78','3')
insert into lesson
values('02','数学','65','3.5')
insert into lesson
values('03','语文','76','2')
insert into lesson
values('04','计算机','56','4')
insert into lesson
values('05','经济','59','2.5')
insert into lesson
values('06','管理','74','3')

insert into student
values('01086201','张1',22,'女','经管')
insert into student
values('01086202','张2',21,'男','经管')
insert into student
values('01086203','张3',22,'女','经管')
insert into student
values('01086204','张4',21,'男','经管')
insert into student
values('01086205','张5',24,'女','经管')
insert into student
values('01086206','张6',23,'男','计算机')
insert into student
values('01086207','张7',20,'女','计算机')
insert into student
values('01086208','张8',22,'男','计算机')
insert into student
values('01086209','张9',21,'女','计算机')
insert into student
values('01086210','张10',23,'男','计算机')

insert into choose
values('01086201','01',67)
insert into choose
values('01086202','01',87)
insert into choose
values('01086203','01',98)
insert into choose
values('01086204','01',57)
insert into choose
values('01086205','01',76)
insert into choose
values('01086206','01',73)
insert into choose
values('01086207','01',63)
insert into choose
values('01086208','01',75)
insert into choose
values('01086209','01',83)
insert into choose
values('01086210','01',79)
insert into choose
values('01086201','02',83)
insert into choose
values('01086202','02',65)
insert into choose
values('01086203','03',88)
insert into choose
values('01086204','03',62)
insert into choose
values('01086205','04',73)
insert into choose
values('01086206','05',76)
insert into choose
values('01086207','06',79)

insert into teacher
values('01','李1')
insert into teacher
values('02','李2')
insert into teacher
values('03','李3')
insert into teacher
values('04','李4')
insert into teacher
values('05','李5')
insert into teacher
values('06','李6')

insert into kecheng
values('01','01')
insert into kecheng
values('02','02')
insert into kecheng
values('03','03')
insert into kecheng
values('04','04')
insert into kecheng
values('05','05')
insert into kecheng
values('06','06')

insert into users
values('123','管理员','123')
insert into users
values('01086201','学生','01086201')
insert into users
values('01086202','学生','01086202')
insert into users
values('01086203','学生','01086203')
insert into users
values('01086204','学生','01086204')
insert into users
values('01086205','学生','01086205')
insert into users
values('01086206','学生','01086206')
insert into users
values('01086207','学生','01086207')
insert into users
values('01086208','学生','01086208')
insert into users
values('01086209','学生','01086209')
insert into users
values('01086210','学生','01086210')
insert into users
values('01','教师','01')
insert into users
values('02','教师','02')
insert into users
values('03','教师','03')
insert into users
values('04','教师','04')
insert into users
values('05','教师','05')
insert into users
values('06','教师','06')