无标题2.sql

一个管理系统,主要是用来管理大学校园的一个大型管理系统

create table message
(sno char(9)primary key,
sname char(20),
ssex char(9),
sage char(4),
stel char(9),
sqq char(10),
smt char(12),
sadd char(25)
);
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310401','牛伟','男','20','6610534','55643343','1345564313','江西南昌');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310402','于涛','男','21','6705832','11543667','1395564310','江西吉安');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310403','舒婷','女','19','6405321','56347838','1367756431','江西南昌');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310405','刘费','男','20','8840541','64646233','1345964315','江西九江');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310407','李阳','男','22','6406564','76544532','1345561136','江西萍乡');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310412','柳叶飞','女','18','6610576','55643321','1355644313','江西南昌');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310414','牛伟','男','19','6610234','54224111','1397064313','江西南昌');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310432','舒婷','女','19','6610534','64758121','1346764313','江苏南京');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310453','胡业成','男','21','6640342','58464897','13970888001','上海市');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310417','刘婷','女','19','6640544','41939323','1333123123','江西广丰');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310421','涛于','女','20','6673543','4563321','1348764313','江西南昌');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310411','谢东郭','男','20','6610534','55643343','1342564323','广东广州');
insert into message(sno,sname,ssex,sage,stel,sqq,smt,sadd)
values ('610310491','牛伟','男','20','6702262','58432554','1345521343','广东汕头');