Mailing List Archive


Back to the month index Back to the list index
Doug Salot (Doug.Salot@mri.com)
Tue, 7 Jan 1997 17:00:46 -0800 (PST) 

Date: Tue, 7 Jan 1997 17:00:46 -0800 (PST)
From: Doug Salot <Doug.Salot@mri.com>
Subject: Re: [mSQL] _seq feature request
Message-Id: <Pine.SUN.3.95.970107165736.23018A-100000@sun243>

On Tue, 7 Jan 1997, Eric Litman wrote:

> Often I find that I need to maintain per-row, incremental counters in my
> databases (i.e. row access counter). It would be nice to be able to
> employ _seq to create a sequence field which is unique only to a
> single row/column, in addition to being able to use it to generate
> values unique to an entire table.
>
> Thoughts?

The "interesting" feature about _seq is that it is unique for a table.
I think what you really want is just an atomic increment. mysql
allows you to do things like "update foo set counter=counter+1"
which does what you want, but I don't remember if mSQL has this
feature (yet).

-- Doug

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!