|
Where I used to work we would run like this
Select from table where id="1";
UPDATE table
SET id="1"
where
id="2"
;
Select from table where id="1";
Rollback;
After the SQL ran, View the output results to verify it ran successfully. Then run it without the rollback line. This was with DB2 though. I don't know about MySQL.
|