List:General Discussion« Previous MessageNext Message »
From:harmen-mysql Date:January 20 2005 3:03pm
Subject:Re: Undo function?
View as plain text  
On Thu, Jan 20, 2005 at 08:58:18AM -0600, Jay Blanchard wrote:
> [snip]
> I get very nervous when I log onto my database via SSH and type in
> queries 
> manually. Take the following query for example:
> 
> Delete FROM Users WHERE User_ID = 5;
> 
> If I hit return before I start typing WHERE then things would be 
> disastorous! Is there any type of undo function with MySQL?
> [/snip]
> 
> You'll want to read this....
> 
> http://dev.mysql.com/doc/mysql/en/COMMIT.html

And try:
$ mysql --i-am-a-dummy

that makes it refuse deletes without 'where'

Good luck,
Harmen



-- 
                                The Moon is Waxing Gibbous (81% of Full)
Thread
Undo function?shaun thornburgh20 Jan
  • Re: Undo function?Martijn Tonies20 Jan
  • Re: Undo function?DuĊĦan Pavlica21 Jan
RE: Undo function?Jay Blanchard20 Jan
  • Re: Undo function?harmen-mysql20 Jan
RE: Undo function?Artem Koltsov20 Jan
  • RE: Undo function?Andy Eastham20 Jan
Re: Undo function?John Pignata20 Jan