[Resolved] MySQL Duplicate Entry

[jaZon]

MySQL said:

Duplicate entry '127' for key 1

Key 1 is being auto-incremented. It doesn't matter what I try to enter. Even if I try to assign key 1 a diff value it still gives the error. Ideas?

[kevinsequeira]

how are u trying to enter the data, through a query ???

post the query ...

reg
kevin

[YappyDog]

Your key column is probably defined as a tinyint which has a max size to it. Change it to an "int" and you should be fine.

[ahundiak]

Use NULL in your insert statement and let the system assign the value.

CREATE TABLE person
(
person_id INT AUTO_INCREMENT,
name CHAR(20)
);

INSERT INTO person VALUES(NULL,'A Name');

[jaZon]

Your key column is probably defined as a tinyint which has a max size to it. Change it to an "int" and you should be fine.

that was it...thx guys