Say I have a very simple table, called `table1` with two columns, `id` and `price`.
if I execute "SELECT table1.* FROM table1;" I get
Now, lets say I write a program that has an infitie loop where it executes "UPDATE table1 SET price=RAND() WHERE id=3;"
Now lets say I have 100 if those programs running at the same time. Is it possible that one of those UPDATEs would fail because the same record is being edited by another program?