table.
Dean Harding.
> -Original Message-
> From: Bryan Waters [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 23 February 2003 1:33 pm
> To: [EMAIL PROTECTED]
> Subject: Re: Cumulative Balance Field
>
> That won't exactly work...first I insert the record...then I upd
MySQL guarantees that individual statements are atomic, so you can use
something like this:
UPDATE mytable SET balance = balance + 100
Of course, you'd have to provide the right WHERE clause...
Dean Harding.
> -Original Message-
> From: Bryan Waters [mailto:[EMAIL PROTECTED]
> Sent: Sun