AUTO_INCREMENT
| From: | Joris Kluivers | Date: | Sun, 04 Mar 2001 11:58:33 +0000 |
| Subject: | AUTO_INCREMENT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7103@lists.php.net to get a copy of this message | ||
hi,
i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message
text, username varchar(100), UNIQUE id (id);
I insert records with:
INSERT INTO chatmessages (message, username) VALUES ('$message', '$username')
this works fine (for a while), i can insert messages and retreive them with php.
But after some time i get the error:
ERROR 1062: Duplicate entry '127' for key 1
but how can this be because i've set it to AUTO_INCREMENT.
can someone help me?
thanks in advance
Joris Kluivers