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

Категории