Read your SQL back as one sentence before you run it

You run an UPDATE by hand on production and the client answers Rows matched: 84520 (MySQL) or UPDATE 84520 (PostgreSQL). You expected about 300. The WHERE clause is missing, or it is there and does not say what you thought it said. This is the oldest accident in hands-on database work, and it does not come from not knowing SQL. It comes from the...