MySQL Forums
Forum List  »  InnoDB

How do you set a transaction around an UPDATE?
Posted by: mySequel 95
Date: October 13, 2008 12:23PM

Hi. I'm using MySQL 4.1.20-standard via the phpMyAdmin 2.5.7 console in a FireFox browser. I need to run the following command and roll it back afterwards,

UPDATE GraphicTable
SET filename1 =
(SELECT g.preid FROM GraphicAssoc g WHERE g.grid = gid)

I thought that I can just say BEGIN; and then ROLLBACK; after the statement, but that doesn't work. Your help is much appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
How do you set a transaction around an UPDATE?
3046
October 13, 2008 12:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.