Re: can you have a collumn roll over with auto_increment

On Nov 11, 3:47 pm, p...@xxxxxxxxx (Paul DuBois) wrote:
mmccaws2 wrote:
I have an integer field that tracks entries. The question I have is
can I set an option so that when auto_increment reaches it's maximum
integer value, it will start all over at zero. I'm deleting every 15
minute the earlier entries, so I'm not too worried about the table
growing too large. Can mysql be set to roll once it's max value is
reached?

No.

Ok damn

.

Relevant Pages

  • Re: can you have a collumn roll over with auto_increment
    ... mmccaws2 wrote: ... it will start all over at zero. ... I'm deleting every 15 ... Can mysql be set to roll once it's max value is ...
    (perl.dbi.users)
  • How to "Archive" a text file with multiple handles open
    ... I'm looking for a way to use CopyToand then "zero out" ... I've found no real discussions regarding DELETING text in a ... How can you use a binarywriter or similar ... you can't use the traditional FileInfo instantiation with the Truncate ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Hand propping a plane
    ... Any time I planned to pull zero or negative G's in the T-6 I'd crack ... After cleaning bird up I went and did my thing ... Speaking about zero and negative G's. ... do a slow roll without engine cutting out. ...
    (rec.aviation.piloting)
  • Re: Whats your favourite FLOSS?
    ... Derek Broughton wrote: ... >> stuff in a MySQL db. ... > just deleting that collection.db and see what happens. ... I changed the database to MySQL and that _half_ worked. ...
    (Debian-User)
  • Database problem
    ... I changed the Allow Zero Property on all the fields that ... >You have a point with the Allow Zero Length property ... >Dim mySQL ... >myConnString = Application ...
    (microsoft.public.frontpage.programming)