1、插入学生及相关联信息
student学生表
ScoreID |
分数ID |
StudenID |
学生ID |
SbujectID |
科目ID |
Score |
分数 |
State |
状态 |
CreatedTime |
创建时间 |
subject科目表
studentID |
学生ID |
Stedentname |
学生姓名 |
Age |
年龄 |
Gender |
性别 |
State |
状态 |
CreatedTime |
创建时间 |
score分数表
ScoreID |
分数ID |
StudenID |
学生ID |
SbujectID |
科目ID |
Score |
分数 |
State |
状态 |
CreatedTime |
创建时间 |
插入语法(增)
插入学生表信息(增:插入单行信息)
insert into stedent (studentname,age,gender) values(‘张三’,’18’,’男’)
insert into stedent (studentname,age,gender) values(‘李四’,’19’,’女’)
insert into stedent (studentname,age,gender) values(‘王五’,’20’,’男’)
插入科目表信息(增:插入单行信息)
insert into subject (subjectname) values (’数学’)
insert into subject (subjectname) values (’语文’)
insert into subject (subjectname) values (’英语’)
插入学生科目成绩表【成绩表】(增:插入单行信息)
insert into score (studentID,subjectID,score) values (1,1,85)
insert into score (studentID,subjectID,score) values (1,2,57)
insert into score (studentID,subjectID,score) values (1,3,90)
insert into score (studentID,subjectID,score) values (2,1,70)
insert into