First dev, seems like an honest mistake and not on them. They weren’t properly informed of the schema, and seniors signed off before the script was run.
Second dev - it happens, but this is why backups are crucially important, and always test the code before running it on prod, even if it’s a short script like this one.
First dev, seems like an honest mistake and not on them. They weren’t properly informed of the schema, and seniors signed off before the script was run.
Second dev - it happens, but this is why backups are crucially important, and always test the code before running it on prod, even if it’s a short script like this one.
If you didn’t take prod down at least once in your career, are you even a developer?
I remember learning about operator precedence in SQL the hard way at 4pm on a Friday. I wasn’t popular that day, and I never made that mistake again.