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
- 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
- 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
- ANSI Standard Syntax for DELETE (Apprentice): Remove rows with DELETE FROM, always limited by a WHERE clause you've checked with a SELECT first.