This bug was fixed to 4.0.17, it happened when you inserted a negative value manually into an auto_increment column
for more info see: http://bugs.mysql.com/bug.php?id=1366 On Mon, 5 Jan 2004, Donald Henson wrote: > Please post your table schema. As to why <bignbr> rather than zero, I'll > have to defer to the experts. > > Don Henson > > On Sun, 2004-01-04 at 16:52, Mike Mapsnac wrote: > > I use both metods and they works But when I make another insert I receive a > > message > > ERROR: 1062 Duplicate entry '2147483647' for key 1. > > > > Why id (primaty , and auto_increment) start from 2147483647 and not from 0 > > or 1 > > > > Thanks cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
