xchg

I was bitten by this once when I didn't know that. I had an application that rarely did inserts and had autocommit turned off. So one select freezed now() for few days until next insert. The result was me having few straight days logged into the timesheet over weekend.