I have a requirement to use a sequence number table that I can reserve a
block of sequences, (so auto increment is not suitable).
This is my proposed table structure
create table SEQNO (
SEQNO INT UNSIGNED NOT NULL DEFAULT 0,
SESSION VARCHAR(10),
LOCK_TIMEOUT TIMESTAMP);
my blocks will go up in 100's, using SQL like
update SEQNO set SEQNO = SEQNO + 100;
My question is, is there any way to get the database to roll over the int
value when it gets to 4,294,967,295?
In my tests it goes upto the max value and stays there. I could do it
programmatically, but it would be so much nicer if the database rolled over
the value.
for example
4,294,967,200
+ 100
-------------
4
Any ideas?
I have read manual, and MySQL book regarding sequences, but could not find
anything relevant.
Thanks
Robin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
