Re: can you have a collumn roll over with auto_increment



On Nov 11, 2007 3:58 PM, mmccaws2 <mmccaws@xxxxxxxxxxx> 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?

May we ask what you are really trying to do? Perhaps there is another
way to accomplish your goals.

ER
.



Relevant Pages

  • 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: To a Programmer or Instructor
    ... Anywhere from zero to one-million. ... and the goals. ... Took a college class. ... Went, "WHOA! ...
    (comp.programming)
  • Re: Firepower Match Feature
    ... I assume your goal is to basically have the game set on free play. ... just set adjustment 18 to zero to accomplish this if that's the case? ...
    (rec.games.pinball)
  • Re: Choosing the correct weight in fgoalattain
    ... > I am using fgoal attain to optimise a multivariable problem. ... Should by weight be a vector of zeros of ... rather than goals to be achieved. ... setting all elements of the weight vector to zero when the goal ...
    (comp.soft-sys.matlab)
  • Re: icon removal
    ... > how do i rearrange my desktop icons after deleting?? ... Auto Arrange? ... What are you trying to accomplish? ...
    (microsoft.public.windowsxp.help_and_support)