At 10:06 AM +0100 9/13/01, Robin Keech wrote:
>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
Why 4? You want the value mod 4,294,967,296?
Write your update like this:
update SEQNO set SEQNO = MOD(SEQNO + 100, 4294967296)
>
>
>Any ideas?
>
>I have read manual, and MySQL book regarding sequences, but could not find
>anything relevant.
>
>Thanks
>
>Robin
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
