This chapter discusses SQL statements that modify the contents of database tables. It covers the following exam topics:
Using the INSERT and REPLACE statements to add new records to a table
Using the UPDATE statement to modify existing table records
Using the DELETE and TRUNCATE statements to remove records from a table
Handling duplicate key values
Privileges required for statements that modify tables