Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^2: PM Confessional

by Jenda (Abbot)
on Jan 19, 2011 at 17:48 UTC ( #883176=note: print w/replies, xml ) Need Help??

in reply to Re: PM Confessional
in thread PM Confessional

That's why I (prettymuch always) stick the handwritten updates and deletes between BEGIN TRANSACTION and ROLLBACK and if and only if I get a sane "N rows affected" message do I select and run just the statement.

Saved my butt a few times.

Enoch was right!
Enjoy the last years of Rome.

Replies are listed 'Best First'.
Re^3: PM Confessional
by Tux (Abbot) on Jan 20, 2011 at 07:18 UTC

    Sane way of operating. It will also protect you fro the less obvious mistake of writing

    delete from table where key > 0;

    instead of

    delete from table where key < 0;

    which is only one key apart. I know someone else who did that.

    This thread is not about errors someone else made, but I will still tell one from the recent past:

    After months of preparing and exercising all the needed commands for the move of one production platform to a newer platform of a more modern architecture, someone (not in our company) issued the main "rsync" command (which also had a --delete) THE WRONG WAY AROUND and deleting two days of work. The restore from backup took 6 hours and regained 1 day of work.

    Enjoy, Have FUN! H.Merijn

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://883176]
[shmem]: karlgoethebier: isn't bike riding a way of fixing lumbago?
[karlgoethebier]: shmem: scheiss technik
[karlgoethebier]: shmem: yes - i f you manage it to get on the bike. and pray if you must stop...
[shmem]: in the french alpes, at the end of a gravel road, we had a beer at a hut - and heard an enduro coming up.
[shmem]: not by the road, but from there below where you wouldn't want to walk.
[shmem]: the biker stopped the machine at the table and took off his helmet.

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (8)
As of 2017-06-25 20:06 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (570 votes). Check out past polls.