Hacker News new | ask | show | jobs
by juan_juarez 4856 days ago
Hell - this could have been avoided if they weren't using graphical tools or had a database that used transactions.
2 comments
krallja 4856 days ago
Neither of those things would have fixed this problem.

1. "Oops, I wrote TRUNCATE TABLE User instead of TRUNCATE TABLE Raids"

2. Transaction complete. ... ... "oops!"

link
whatshisface 4856 days ago
Well, to be fair it's harder to type User than it is to miss your rightclick by something that could have only been a few pixels.
link
derekp7 4855 days ago
Also, I can't tell you how many times I've attempted to click on a button on a web form, and it was still loading and the button moved (along with a different button appearing in its place).
link
themonk 4856 days ago
Why type "TRUNCATE TABLE Raids" every time? Type it once, test it, save as script, schedule that script.
link
krallja 4855 days ago
That is definitely another bug in this company's process. This should have been automated. It's much harder to screw up running a script!
link
ptaipale 4855 days ago
Not really. You obviously haven't (yet) done anything like update t1 set status=0; where status=4; when you wanted to release (set status to 0) objects that are stuck in state 4, and let all other objects keep their existing statuses.

This is an easy mistake to make on command line. I hate GUIs too but not having one doesn't really help when your fundamental operating model is wrong.

link
devicenull 4855 days ago
And that's why you use --i-am-a-dummy on the command line :)

http://dev.mysql.com/doc/refman/4.1/en/mysql-command-options...

link