练习_20110513.docVIP

【实验名称】SDQ查询使用 【实验拓扑】 【实验步骤】 建数据库jwgl 代码：create database jwgl 二、新建数据表student 代码： create table student ( student_id char(10) primary key, student_name nchar(10)not null, sex int not null, age int not null, birth nchar(10) not null, class_id nchar(10) not null, enteance_date nchar(10) not null, home_addr nchar(30), ) insert into student values(g940210,张虹,1,15,1984-9-1,g9902,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940212,林红,0,22,1984-6-1,g9901,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940213,曹雨,1,21,1983-12-1,g9902,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940214,苪华,1,18,1984-9-1,g9901,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940215,李红【大】,0,17,1983-9-9,g9902,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940216,李红【小】,0,22,1984-9-8,g9901,1999-9-1,南京市鼓楼区平岗3号) insert into student values(g940217,赵青,1,19,1985-9-9,g9902,1999-9-1,南京市鼓楼区平岗3号) insert into student(student_id,student_name,sex,age,birth,class_id,enteance_date) values(g940218,林海,1,16,1985-10-9,g9901,1999-9-1,NULL) 新建数据表class_info 代码： create table class_info ( class_id nchar(10) primary key, class_name nchar(20), ) insert into class_info values (g9901,网页一班) insert into class_info values (g9902,网页二班) insert into class_info values (g9903,网页三班) 建数据表course 代码： create table course ( class_id nchar(10) , student_id nchar(10), grade int ) insert into course values (1,g940210,60) insert into course values (2,g940212,90) insert into course values (1,g940213,87) insert into course values (2,g940210,88) insert into course values (3,g940210,98) select * from course 建数据表course_info 代码： create table course_info ( courseid int, coursename nchar(10), ) insert into course_info values (1,flash) insert into course_info values (2,fireworks) insert into course_info values (3,ps) select * from course_info ) select * from course_info 三、对student表做如下操作 插入一条学生记录，student_id：g940220，student_name：赵凯，sex：1，age：20，birth：1985-1-9，class_id：g9903，entrance_date：1999-9-1，home_addr：江苏市仪征青年路16号。 代码：insert