This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

The SQL-data change statements are INSERT, UPDATE and DELETE. Many people call these the SQL "update" statements which is okay, provided you don't mix up "update" (lower case, meaning INSERT or UPDATE or DELETE) with UPDATE (upper case, meaning only UPDATE). We prefer the term "data change statements" because it's unambiguous.

In this chapter, we'll discuss changes to SQL-data in all aspects, including hidden changes, changes of Views, the syntax of INSERT, UPDATE and DELETE, access (Privilege) rules and the new SQL3 feature: changes to joined Tables. But we won't talk about four important and relevant matters because they rate chapters of their own:

Multiple data changes and transactions discussed in Chapter 36 "SQL Transactions".

Data changes and Constraints discussed in Chapter 20 "SQL Constraints and Assertions".

Data changes and Triggers discussed in Chapter 24 "SQL Triggers".

Data changes through Cursors discussed in Chapter 39 "Embedded SQL Binding Style" in particular, data changes with "positioned" UPDATE/DELETE.

After reading this chapter, you'll know everything that there is to know about the SQL data-change statements taken in isolation. But we give you fair warning: we'll revisit some of these points when we put them in context later on.