Just a few weeks ago we had an auth service. For some reason our CBO cannot login, reset password email takes a long time to come(another story for other days).

So I generated an argon2 hash, manually loggin to db to set it. I want to run:

``` update users set hash = 'hash' where email = 'cbo email'; ```

Unfortunately, the `;` character was used as part of the hash so during copy and paste the whole thing become:

``` update users set hash = 'hash'; where email = 'cbo email'; ```

It ran immediately and reset password for all of our users.

I had to make a new db from the point in time recovery to copy password back.

always use transaction and commit the result will be the way from now on.