第八章上机

来源：互联网发布：php post 接收编辑：程序博客网时间：2024/05/28 15:47
INSERT Student VALUES('S1201302001','zhangsan','张三','男',1,'101062768866','解放路','1991-1-1','zhangsan@126.com')INSERT Student VALUES('S1201302002','lisi89','李四','男',1,'13812345678','长江路','1991-2-1',null)INSERT Student VALUES('S1201302003',DEFAULT,'王五','男',1,'13912345678',DEFAULT,'1991-5-3',null)INSERT Student VALUES('S1201302004','wanglili','王丽丽','女',1,'13112345678',DEFAULT,'1991-6-2','wanglili@sohu.com')INSERT Student VALUES('S1201302005',DEFAULT,'张峰','男',1,'13212345678',DEFAULT,'1991-8-8',null)INSERT Subject(SubjectName,ClassHour,GradeId)SELECT '走进java编程世界',40,1 UNIONSELECT 'HTML和CSS网页技术',60,1 UNIONSELECT 'C#语言和数据库技术',70,1 INSERT Result(StudentNo,SubjectId,StudentResult,ExamDate)SELECT 'S1201302001',1,80,'2013-9-13' UNIONSELECT 'S1201302001',1,45,'2013-9-13' UNIONSELECT 'S1201302002',2,90,'2013-10-18' UNIONSELECT 'S1201302002',2,60,'2013-10-18' INSERT Address_IS(Id,SName,Phone,Address,Email)SELECT StudentNo,StudentName,Phone,Address,EmailFROM StudentSELECT StudentName,Phone,Address,EmailINTO Address_SIFROM Student
0 0