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
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