can you have a collumn roll over with auto_increment

From: mmccaws@xxxxxxxxxxx (Mmccaws2)
Date: Sun, 11 Nov 2007 13:58:00 -0800

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?

Thanks
Mike

.

Follow-Ups:
- Re: can you have a collumn roll over with auto_increment
  - From: E R
- Re: can you have a collumn roll over with auto_increment
  - From: Paul DuBois

Prev by Date: Net::MySQL hangs
Next by Date: Re: can you have a collumn roll over with auto_increment
Previous by thread: Net::MySQL hangs
Next by thread: Re: can you have a collumn roll over with auto_increment
Index(es):
- Date
- Thread

Relevant Pages

Re: Postgres or Mysql
... > Last I heard mysql does no type checking on values inserted into a ... > You can insert the string "big dog" into an integer field and get no ...
(comp.databases.informix)
Re: Postgres or Mysql
... Last I heard mysql does no type checking on values inserted into a ... You can insert the string "big dog" into an integer field and get no ...
(comp.databases.informix)