Typo of the day
Here is what I meant to type:
Delete from tablename where fieldname='value'
Here is what I typed:
Delete from tablename where fieldname-'value'
Of course, the first statement deletes one record. The second one deletes all but that record.
Fortunately, I had a current backup so there was not major loss.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
The Webmistress posted this at 13:50 — 14th May 2003.
She has: 5,586 posts
Joined: Feb 2001
:eek: OMG, you were lucky then!
Jack Michaelson posted this at 15:09 — 14th May 2003.
He has: 1,733 posts
Joined: Dec 1999
Hmmm why are the - and the = next to each other you might ask...
:eek:
andy206uk posted this at 08:28 — 15th May 2003.
He has: 1,758 posts
Joined: Jul 2002
Scary... i'll have to remember that for future reference!
(note to self... must make backups).
mairving posted this at 10:45 — 15th May 2003.
They have: 2,256 posts
Joined: Feb 2001
I think I have done it all. A while back I meant to do this:
rm *.gz which will remove every file with a .gz (compressed) extension
Well, my little typo then was this:
rm * .gz
Note the space between the * and .gz. The difference was that this deleted every file in that directory. Fortunately, it was in a directory with only a few files.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
necrotic posted this at 02:44 — 20th May 2003.
He has: 296 posts
Joined: May 2002
Dang, watch those typos! You might delete the whole system!
clubart posted this at 04:29 — 23rd May 2003.
They have: 18 posts
Joined: Feb 2002
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.