Re: NextNumbers Tables

Pablo Sanchez wrote:

> 2) Set a local variable within the UPDATE:
>
> UPDATE mytable
> set @my_next_val = next_val,
> next_val = next_val + 1
> ...
> COMMIT;
Hmm, is the order of evaluation guaranteed? What's to stop a particular implementation from doing the second one first?

Larry Coon
University of California
larry_at_assist.org
and lmcoon_at_home.com Received on Wed Feb 12 2003 - 13:00:15 CST