第八章上机1

最新推荐文章于 2022-04-03 22:44:00 发布

Star_Gemini

最新推荐文章于 2022-04-03 22:44:00 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/qq_36074093/article/details/53242344

版权

INSERT INTO Student (StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate,Email) 
VALUES ('S1201302001','zhangsan','张三','男',1,'01062768866','解放路','1991-1-1','zhangsan@126.com');

INSERT INTO Student (StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate) 
VALUES ('S1201302002','lisi89','李四','男',1,'13812345678','长江路','1996-2-1');

INSERT INTO Student (StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate) 
VALUES ('S1201302003',DEFAULT,'王五','男',1,'13912345678',DEFAULT,'1996-2-1');

INSERT INTO Student (StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate,Email) 
VALUES ('S1201302004','wanglili','王丽丽','女',1,'13112345678',DEFAULT,'1994-6-2','wangll@sohu.com');

INSERT INTO Student (StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,Address,BornDate) 
VALUES ('S1201302005',DEFAULT,'张峰','男',1,'13212345678',DEFAULT,'1991-8-8');