MySQL Tutorial

Chapter 5. Inserting, Deleting, and Updating Data

In this chapter, we will look at how to insert and change data in your MySQL database with the INSERT, DELETE, and UPDATE statements.

We will cover the following:

• Using INSERT

• Using DELETE

• Using UPDATE

• Uploading data with LOAD DATA INFILE

• Extensions: REPLACE and TRUNCATE

We have now moved into the DML (Data Manipulation Language) aspects of SQL. After we have learned how to insert data into a database, we will spend the next few chapters learning the many and varied ways to retrieve data from a database.