use test;
drop table phones;
create table phones (id int, name varchar(20), phone varchar(12));
insert into  phones values (1,'Meyers, Chris',  '343-4349');
insert into  phones values (2,'Smith, Robert',  '689-1234');
insert into  phones values (3,'Jones, Janet',   '483-5432');
insert into  phones values (4,'Barnhart, Ralph','683-2341');
insert into  phones values (5,'Nelson, Eric',   '485-2689');
insert into  phones values (6,'Prefect, Ford',  '987-6543');
insert into  phones values (7,'Zigler, Mary',   '567-8901');
insert into  phones values (8,'Smith, Bob',     '689-1234');

