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: 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)
  • Re: Cobol Myth Busters
    ... and far too many people fail to see. ... Any endeavor needs to be measured primarily against its ... It doesn't matter how clear or beneficial your goals are; ... It's kind of like replacing a data exception with a divide by zero ...
    (comp.lang.cobol)