NYCPHP Meetup

NYPHP.org

[nycphp-talk] mysql concurrency redux

Chris Shiflett shiflett at php.net
Tue Feb 24 12:07:55 EST 2004


--- David Mintz <dmintz at davidmintz.org> wrote:
> How is using a transaction supposed to prevent another client from
> sneaking in an update after I compare, but before I write?

Transactions are guaranteed to be atomic. So, the database makes sure
there is no such thing as "sneaking in an update after I compare, but
before I write."

Hope that helps.

Chris

=====
Chris Shiflett - http://shiflett.org/

PHP Security - O'Reilly
     Coming mid-2004
HTTP Developer's Handbook - Sams
     http://httphandbook.org/
PHP Community Site
     http://phpcommunity.org/



More information about the talk mailing list