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:
> SQL-query : [Edit]
> Duplicate entry '127' for key 1
> I can not insert any more data to this table. This is an important
> issue, please help me to resolve this.
Change the field type for key 1 to an int (not a tinyint).
Linux rocks!!! http://www.dedserius.com/