insert.sql

学生信息管理系统

insert into speciality values('01','软件技术','01')
insert into speciality values('02','广告技术','01')
insert into speciality values('03','国际物流','03')

insert into teacherInformation values('A001','王向中','01','男')
insert into teacherInformation values('A002','张卫','01','女')
insert into teacherInformation values('A003','王利群','01','男')
insert into teacherInformation values('A004','董陶陶','01','女')
insert into teacherInformation values('A005','迟成勇','01','男')

insert into teacherphone (teacher_id,telephone)values('A001','6666666')
insert into teacherphone (teacher_id,telephone)values('A002','5555555')
insert into teacherphone (teacher_id,telephone)values('A003','8888888')
insert into teacherphone (teacher_id,telephone)values('A004','7777777')
insert into teacherphone (teacher_id,telephone)values('A005','9999999')

insert into teacheremail (teacher_id,email)values('A001','[e-mail]')
insert into teacheremail (teacher_id,email)values('A002','[e-mail]')
insert into teacheremail (teacher_id,email)values('A003','[e-mail]')
insert into teacheremail (teacher_id,email)values('A004','[e-mail]')
insert into teacheremail (teacher_id,email)values('A005','[e-mail]')