[thelist] auto-increment with mysql

[Dan Romanchik]

I did this once, mistakenly making the index a smallint instead of an
unsigned int. What a pain that was to troubleshoot.

It definitely does not make sense to have it start over. You could lose a
lot of data that way.

Dan
----------------------------------------------------------------------------
Dan Romanchik - Web Developer
dan at danromanchik.com, 734-930-6564


----- Original Message -----
From: "Chris W. Parker" <cparker at swatgear.com>
To: <thelist at lists.evolt.org>
Sent: Thursday, July 17, 2003 8:22 PM
Subject: RE: [thelist] auto-increment with mysql


> rudy <mailto:rudy937 at rogers.com>
>     on Thursday, July 17, 2003 5:01 PM said:
>
> >> When the auto-increment column gets to it's max (let's say
> >> smallint(5) unsigned), does it start back at 1 again or does it just
> >> conk out?
> >
> > it conks out gloriously
>
> In that case should I not try to save as much space/overhead as possible
> and just use an unsigned int? IIRC that goes to 2.5+ million correct?
>
> That seems like plenty, but I definitely don't want this program to stop
> working over a period of a year because it's hit the limit.
>
> Also, don't YOU think it makes sense to have it start over? Is the way
> mysql behaves the way most databases behave? What are the benefits to
> not having start over (if any)?
>
>
> Thanks,
> Chris.
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> Evolt.org conference in London, July 25-27 2003.  Register today at
http://evolt.org.uk
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>