INSERT INTO Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,[Address],Birthday,Email)
VALUES('s120130200111','zhangsan','张三',0,1,'01062768866','解放路','1991-1-1','zhangsan@126.com')
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email)
VALUES('s120130200211','lise89','李四',0,1,'01062768867','上海路','1991-1-2',null)
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email)
VALUES('s120130200311','default','王五',1,1,'01062768868','法租界','1991-1-3',null)
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email)
VALUES('s120130200411','zhaolili','王丽丽',1,1,'01062768869','default','1991-1-4','zhaoliu@126.com')
INSERT INTO St
C第八章上机5
最新推荐文章于 2020-12-24 02:22:17 发布
这篇博客展示了几个SQL数据库操作,包括INSERT语句用于插入学生信息,UPDATE用于修改学生地址、年级和邮箱,以及Result表的成绩更新。同时,还进行了Subject表的创建和更新,涉及到科目名、课时和年级ID。
摘要由CSDN通过智能技术生成