Modifying Data

In the previous chapter we looked at various ways to query data from a database. Now we will look at how to insert new records into a database, how to update existing records and also how to delete records.

Updated

Modifying Data

  1. Inserting Data (Apprentice): Add rows to a table with INSERT, for every column or only some, one row or several at once, without breaking a foreign key.

Updating Data

  1. ANSI Standard Syntax for UPDATE (Apprentice): Change existing rows with UPDATE ... SET, and always limit it with a WHERE clause you've checked with a SELECT first.

Deleting Data

  1. ANSI Standard Syntax for DELETE (Apprentice): Remove rows with DELETE FROM, always limited by a WHERE clause you've checked with a SELECT first.