CHAPTER 8Changing Table Contents
In this chapter you’ll learn more about changing the contents of tables. Specifically, you’ll learn
How to add, modify, and remove rows using the INSERT, UPDATE, and DELETE statements.
That a database transaction may consist of multiple INSERT, UPDATE, and DELETE statements.
How to make the results of your transactions permanent using the COMMIT statement, or undo their results entirely using the ROLLBACK statement. ...