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:[EMAIL PROTECTED] > Sent: Thursday, January 20, 2005 8:17 AM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > 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/[EMAIL PROTECTED]
