MySQL Crash Course

9 Inserting, Updating, and Deleting Data

In this chapter, you’ll learn to insert, update, and delete data from tables. You’ll practice ways to insert data from one table to another, use queries to update or delete data from a table, and create a table that automatically increments a numeric value into a column as you insert rows.

Inserting Data

So far, you’ve been querying data from tables. But how did the data get into the tables in the first place? Typically, you insert data using the insert statement.

Adding rows to a table with the insert statement is known as populating a table. You specify the name of the table, the names of the columns ...