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.
> -----Original Message-----
> From: shaun thornburgh [mailto:shaunthornburgh@stripped]
> Sent: Thursday, January 20, 2005 8:17 AM
> To: mysql@stripped
> Subject: Undo function?
> 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:
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.