On Fri, 7 Sep 2001, scott.alexander wrote:
> Hi,
>
> Why would I loose all of a sudden my autoincrement feature on a table.
>
> I have not changed the table definition and all of a sudden I get
> DUPLICATE ENTRY for KEY 1 errors.
>
BTW it is of type INT and the last entry was only 22700.
Below is an output from mysql
SHOW COLUMNS FROM message;
+----------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+----------------+
| message_id | int(11) | | PRI | NULL | auto_increment |
| id | int(11) | | MUL | 0
thanks again
Scott
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
