You haven't given your table definition, but I'm guessing that your primary key is a
TINYINT, which only supports -128 to +127. Figure out how big you need that key to
be, then change the column as appropriate to a SMALLINT, MEDIUMINT, INT, or BIGINT.
Steve Meyers
> -Original Message---
Tried turning force on so that it'll ignore errors? That way only
duplicate rows are ignored?
*^*^*^*
Michael McGlothlin <[EMAIL PROTECTED]>
http://mlug.missouri.edu/~mogmios/projects/
On Fri, 19 Oct 2001, Robert Trembath wrote:
> I have some nice database for a biotech lab running on the windo
In the last episode (Oct 19), Robert Trembath said:
> I have some nice database for a biotech lab running on the windows
> version of mysql 3.23 on a W2K server. For some reason when my ID or
> Auto-increment field get to 127 I can't insert any additional records. I
> get the following error:
Cha
Robert Trembath wrote:
>
> I have some nice database for a biotech lab running on the windows
> version of mysql 3.23 on a W2K server. For some reason when my ID or
> Auto-increment field get to 127 I can't insert any additional records. I
> get the following error:
>
> Error
> SQL-query : [Edi
