ew table first.
>
>Thanks
>
>
>-Original Message-
>From: Will French [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 04, 2001 1:50 PM
>To: MySQL
>Subject: RE: auto increment problems
>
>
>> Error: 1062 - Duplicate entry '2147483647' for key 1
>T
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 1:50 PM
To: MySQL
Subject: RE: auto increment problems
> Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signe
> Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains > 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
> Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains > 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
