java第三次作业

1、

a、create database phone_book;
        use phone_book;
b、create table info (id char,name char(8),tel char(11),sex char(2));
c、insert into info values ('1','小李','18704664644','男');
insert into info values ('2','小明','13666324035','男');
insert into info values ('3','小红','15052313654','女');
insert into info values ('4','小花','15636979663','女');
insert into info values ('5','小三','17766523625','男');
insert into info values ('6','小林','13833655362','男');
insert into info values ('7','小周','16356452368','男');
insert into info values ('8','小王','13962233652','男');
insert into info values ('9','小江','13789666635','男');
insert into info values ('10','小刘','18922353362','男');

2.

 3.

 4.