Also a good practice for shakey hands is to start mysql with the
--safe-updates option. This will not allow a delete or update to be
executed without a where clause.
On Thu, 20 Jan 2005 10:55 am, Andy Eastham wrote:
> 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
>> 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
>> 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
>> except where the message states otherwise and the sender is
>> authorized to
>> state them to be the views of any such entity. The information
>> 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
>> 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:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
John Pignata [jpignata@stripped]