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','廣東汕頭');