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
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
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
[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
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
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
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
[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