Need Help w. Table.

[Steve Burrus]

I have tjhis table seen below. It is a simple employees table. I consistently get this eror msg. saying there is a duplicate entry 311549902 for PRIMARY. Now I originally set the id field to be a primary key but I later on tried to remove that. How do I ever oversome this error message?


use test;

create table if not exists personnel_table ( id int(9) not null , first_nm varchar(17) not null, middle_nm varchar(17) , last_nm varchar(17) not null,
addr varchar(30) not null, city varchar(16) not null, state char(2) not null, zip_code int(5) not null, phone char(10),
pager char(10));

insert into personnel_table(id,first_nm, middle_nm, last_nm,addr, city, state, zip_code, phone, pager) values (311549902, 'TINA', 'DAWN',
'STEPHENS', 'RR 3 Box 17A', 'GREENWOOD', 'IN', 47890, 3178784465, NULL),
(44236889, 'LINDA', 'CAROL', 'PLEW', '3301 BEACON', 'INDIANOPLIS', 'IN', 46224, 3172978990, NULL),
(311549902, 'BRANDON', 'SCOTT','GLASS', '1710 MAIN ST.', 'WHITELAND', 'IN', 47885, 3178984321, 3175709980),
(313782439, 'JACOB', NULL,'GLASS', '3789 WHITE RIVER BLVD.', 'INDIANOPLIS', 'IN', 45734, 3175457676, 8887345678),
(220984332, 'MARIA', NULL,'WALLACE', '7889 KEYSTONE AVE.', 'INDIANOPLIS', 'IN', 46741, 3173325986, NULL),
(443679012, 'TIFFANY', NULL,'SPURGEON', '5 GEORGE COURT', 'INDIANOPLIS', 'IN', 46234, 3175679007, NULL),
(259830917, 'STEVE', 'RICHARD','BURRUS', '12808 NOEL RD. APT. 1011', 'DALLAS', 'TX', 75230, 2146281190, 4692507841);