Will this SQL screw up
- by Joshua
I'm sure everyone knows the joys of concurrency when it comes to threading.
Imagine the following scenario on every page-load on a noobily set up MySQL db:
UPDATE stats SET visits = (visits+1)
If a thousand users load the page at same time, will the count screw up? is this that table locking/row locking crap? Which one mysql use.