<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On a small table of about 200 records on an old system that I was
asked to assist with, I did the select * first, then did an UPDATE
forgetting the where clause and updated all rows for a single field
- since it was the older system and one im not in charge of, no one
could point me to backups of any sort - so luckily I had the console
output from my SELECT, copypasta'd out to a text file and
meticulously put back to the right state (not quite row by row, but
groups of rows).<br>
<br>
Now days I always write DELETE and UPDATE statements WHERE clause
first so even if i do accidentally hit go it will error out<br>
<br>
e.g.<br>
DELETE FROM WHERE ID=540;<br>
OR<br>
UPDATE tbl SET WHERE ID=430;<br>
<br>
Then go back add the tbl for the DELETE and the fields for the
UPDATE.<br>
<br>
<br>
<div class="moz-cite-prefix">On 24/12/14 13:27, PRK wrote:<br>
</div>
<blockquote
cite="mid:08198666fab4e5db29561f5fec3e8ce2@mail.digitaljunkie.net"
type="cite">
<p>Is there anyone here who either:</p>
<p>a) Hasn't done the vlan xxx instead of vlan add xxx?</p>
<p>or</p>
<p>b) Hasn't directly seen the vlan xxx instead of vlan add xxx
done?</p>
<p>Or, if you're more of a systems person, haven't locked yourself
out of a server due to a firewall change, or directly seen
someone else do so?</p>
<p>Or, if you're a DBA, done an update to a database table and
missed the where clause, overwriting every single record?</p>
<p>I'd consider these fairly common errors that almost everyone
makes, once, and a fantastic way to evaluate someone's response
under pressure. They're also fantastic teachable moments (once
resolved) as to why certain company processes and procedures
exist.</p>
<p>I'd probably be concerned if the same person made the same
mistake more than once, though.</p>
<p>prk.</p>
<div> </div>
<p>On 2014-12-23 20:48, Andy S. wrote:</p>
<blockquote type="cite" style="padding-left:5px;
border-left:#1010ff 2px solid; margin-left:5px">
<div dir="ltr">I just remember one of my mate told a story about
one particular CCIE doing "switchport trunk allowed vlan xxx"
instead of "switchport trunk allowed vlan add xxx" and caused
an outage. Companies losing money (according to him. It's a
stock trading company). Though it's weird they needed more
time to address where the issue was. </div>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
AusNOG mailing list
<a class="moz-txt-link-abbreviated" href="mailto:AusNOG@lists.ausnog.net">AusNOG@lists.ausnog.net</a>
<a class="moz-txt-link-freetext" href="http://lists.ausnog.net/mailman/listinfo/ausnog">http://lists.ausnog.net/mailman/listinfo/ausnog</a>
</pre>
</blockquote>
<br>
</body>
</html>