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','上海路','1998-1-2',null)
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email)
VALUES('s120130200311','default','王五',1,1,'01062768868','法租界','1995-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 Student(StudentNo,LoginPwd,StudentName,Gender,GradeId,Phone,Address,Birthday,Email)
VALUES('s120130200511','default','张峰',1,1,'01062768865','default','1991-1-5',null)
UPDATE Student SET [Address]='山东省济南市文化路1号院'
WHERE StudentNo='s120130200411'
UPDATE Student SET GradeId=2
WHERE StudentNo='s120130200511'
UPDATE Student SET Email='未知@'
WHERE Email is null
DELETE FROM Student
WHERE Birthday>'1995-1-1'
c#第八章上机6
最新推荐文章于 2022-05-18 16:36:56 发布