/* In this example, a tuple is updated and then the changes are rolled back so it reverts */ SELECT * FROM Musician WHERE name='Jonah Matranga'; NAME -------------------------------------------------------------------------------- INSTRUMENT -------------------------------------------------------------------------------- HOMETOWN -------------------------------------------------------------------------------- Jonah Matranga guitar Berkeley, CA Elapsed: 00:00:00.02 UPDATE Musician SET name='Jonah Sonz-Matranga' WHERE name='Jonah Matranga'; 1 row updated. Elapsed: 00:00:00.01 ROLLBACK; Rollback complete. Elapsed: 00:00:00.04 SELECT * FROM Musician WHERE name='Jonah Matranga'; NAME -------------------------------------------------------------------------------- INSTRUMENT -------------------------------------------------------------------------------- HOMETOWN -------------------------------------------------------------------------------- Jonah Matranga guitar Berkeley, CA Elapsed: 00:00:00.01 SELECT * FROM Musician WHERE name='Jonah Sonz-Matranga'; no rows selected Elapsed: 00:00:00.00 /* And this example shows use of COMMIT to make the changes take effect */ SELECT * FROM Transcriber WHERE transcriber='Steve van Loben Sels'; TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- Steve van Loben Sels sevls@leland.stanford.edu Elapsed: 00:00:00.06 UPDATE Transcriber SET transcriber='Steven Elliot van Loben Sels' WHERE transcriber='Steve van Loben Sels'; 1 row updated. Elapsed: 00:00:00.00 COMMIT; Commit complete. Elapsed: 00:00:00.01 SELECT * FROM Transcriber WHERE transcriber='Steve van Loben Sels'; no rows selected Elapsed: 00:00:00.01 SELECT * FROM Transcriber WHERE transcriber='Steven Elliot van Loben Sels'; TRANSCRIBER -------------------------------------------------------------------------------- EMAIL -------------------------------------------------------------------------------- Steven Elliot van Loben Sels sevls@leland.stanford.edu Elapsed: 00:00:00.00 UPDATE Transcriber SET transcriber='Steve van Loben Sels' WHERE transcriber='Steven Elliot van Loben Sels'; 1 row updated. Elapsed: 00:00:00.01 COMMIT; Commit complete. Elapsed: 00:00:00.01