----- Original Message -----
From: "Steven Fruchter" <[EMAIL PROTECTED]>


> Hi Everyone,
>     I have a big problem, that I bet could be solved pretty simply but I
am
> new to mysql so its killing me and my database.
>
>     Ok heres the problem, suddenly out of no where when my php script
tries
> to (or manually) do a insert it says:
>
>     ERROR 1062: Duplicate entry '127' for key 1
>
<snip>
>     CREATE TABLE custinfo (  id tinyint(4) DEFAULT '0' NOT NULL
<snip>

Hi Steven,

Carefully check out your data types. You used a tinyint for the ID, which
according to another poster, has a maximum limit of 127.
So it can't auto_increment above the maximum limit.

Use int. It can do into the thousands.

Anna


---------------------------------------------------------------------
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

Reply via email to