MySQL 5.0 Certification Study Guide

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