Hi,
I want to add one more thing. Usually manually entered queries must end up
with semicolon so if you hit enter before the end nothing happens.
Regards,
Dusan
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Thursday, January 20, 2005 2:17 PM
Subject: Undo f
[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 of
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 transac
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 b
On Thu, Jan 20, 2005 at 08:58:18AM -0600, Jay Blanchard wrote:
> [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 t
[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?
[/s
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