RE: Cumulative Balance Field

2003-02-22 Thread Dean Harding
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

RE: Cumulative Balance Field

2003-02-22 Thread Dean Harding
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