List:General Discussion« Previous MessageNext Message »
From:Andy Eastham Date:January 20 2005 3:27pm
Subject:RE: Undo function?
View as plain text  
Backups are good too :-)

Andy

> -----Original Message-----
> From: Artem Koltsov [mailto:Artem.Koltsov@stripped]
> Sent: 20 January 2005 15:06
> To: mysql@stripped
> Subject: RE: Undo function?
> 
> Hello,
> 
> If you define table type as InnoDB, you can use transactions (see the link
> below). You will need set AUTOCOMMIT=0, and after you can issue COMMIT or
> ROLLBACK at the end of query or session to submit or cancel a transaction.
> I don't think you can use transactions for mysql system tables because
> they have to be MyISAM type, so the best solution for them will be
> backups.
> 
> http://dev.mysql.com/doc/mysql/en/InnoDB_transaction_model.html
> 
> 
> > -----Original Message-----
> > From: shaun thornburgh [mailto:shaunthornburgh@stripped]
> > Sent: Thursday, January 20, 2005 8:17 AM
> > To: mysql@stripped
> > Subject: Undo function?
> >
> >
> > Hi,
> >
> > 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?
> >
> > Thanks for your help.
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> >
> >
> 
> Attention:
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity. The information contained
> in this message and or attachments is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material.  If you received this in error, please contact the
> sender and delete the material from any system and destroy any copies.
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



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