PDA

View Full Version : Primary Key Update


5861king
Wed 19th Dec '01, 6:14pm
is there anyway of updateing the primary key which is called numberid. this is the command that i'm useing but i get an error message.

INSERT INTO number (numberid,firstname,lastname) VALUES('314','james','bower')

MySQL said:

Duplicate entry '314' for key 1


Please can someone help me
:p

Mitrofan
Wed 26th Dec '01, 7:12pm
Is it possible that you already have a record with numberid='314'?