Re: Undo function?

2005-01-21 Thread Duan Pavlica
PM 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

Undo function?

2005-01-20 Thread shaun thornburgh
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

Re: Undo function?

2005-01-20 Thread Martijn Tonies
Hello, 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

RE: Undo function?

2005-01-20 Thread Jay Blanchard
[snip] 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

Re: Undo function?

2005-01-20 Thread harmen-mysql
would be disastorous! Is there any type of undo function with MySQL? [/snip] You'll want to read this http://dev.mysql.com/doc/mysql/en/COMMIT.html And try: $ mysql --i-am-a-dummy that makes it refuse deletes without 'where' Good luck, Harmen

RE: Undo function?

2005-01-20 Thread Artem Koltsov
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

RE: Undo function?

2005-01-20 Thread Andy Eastham
Backups are good too :-) Andy -Original Message- From: Artem Koltsov [mailto:[EMAIL PROTECTED] Sent: 20 January 2005 15:06 To: mysql@lists.mysql.com Subject: RE: Undo function? Hello, If you define table type as InnoDB, you can use transactions (see the link below). You

Re: Undo function?

2005-01-20 Thread John Pignata
[mailto:[EMAIL PROTECTED] Sent: 20 January 2005 15:06 To: mysql@lists.mysql.com 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