How do you set a transaction around an UPDATE?
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.
Subject
Views
Written By
Posted
How do you set a transaction around an UPDATE?
3046
October 13, 2008 12:23PM
1944
October 23, 2008 01:03PM
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.