Hello,
if there is a MYSQL developer member (or guru), I would
like to ask if there is possible that another query modify
a field between the detection of a target row and the changes
made to it, by an update query.
Let me explain myself a little: suppose we have an update query, like
this:
UP
Please, any idea how to manage concurent requests,
for example like in a shopping cart?
Scenario:
1. I have a counter A (a field in a database row), set to 1, so A=1
2. A client wants 1 unit from A , it checks and it's OK,
there is available.
3. Another client wants 1 unit from A, it check
