insertstudent.sql

来自「学生信息管理系统」· SQL 代码 · 共 12 行

insert into class values('C001','软件技术g0511','01','A001','2005')
insert into class values('C002','软件技术g0411','01','A001','2004')
insert into class values('C003','软件技术g0611','01','A001','2006')

insert into student values('17','xuxu','女','C001','1987/06/05','南京栖霞')
insert into student values('28','kunkun','男','C001','1987/8/19','江苏宜兴')

insert into studentphone(student_id,telephone)values('17','13401921261')
insert into studentphone(student_id,telephone)values('28','13851682001')

insert into studentemail(student_id,email)values('17','[e-mail]')
insert into studentemail(student_id,email)values('28','[e-mail]')