Backups are good too :-)
> -----Original Message-----
> From: Artem Koltsov [mailto:Artem.Koltsov@stripped]
> Sent: 20 January 2005 15:06
> To: mysql@stripped
> Subject: RE: Undo function?
> 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
> > -----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
> 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