Re: Re[2]: transaction support

2004-01-06 Thread Matt Davies
Quoting DeBug <[EMAIL PROTECTED]>: > >>[MySQL] > >>1: START TRANSACTION > >>2: WITHDRAW $50 from account 32146. > >>3: DEPOSIT $50 into account 12345. > >>4: LOG transfer (date/time/teller/etc...) for auditing. > >>5: COMMIT TRANSACTION > > DK> It depends why step 3 failed. > DK> If you want to r

Re[2]: transaction support

2004-01-06 Thread DeBug
>>[MySQL] >>1: START TRANSACTION >>2: WITHDRAW $50 from account 32146. >>3: DEPOSIT $50 into account 12345. >>4: LOG transfer (date/time/teller/etc...) for auditing. >>5: COMMIT TRANSACTION DK> It depends why step 3 failed. DK> If you want to rollback the transaction to the beginning on any error,