17. Modifying Data

Keywords Introduced

INSERT INTO • VALUES • DELETE • TRUNCATE TABLE • UPDATE • SET

Having exhausted our discussion of retrieving data from databases, we now move on to the question of how to modify data in a database. There are three basic scenarios as to how data can be modified:

Image Inserting new rows into a table

Image Deleting rows from a table

Image Updating existing data in specific rows and columns in a table

As may be surmised, inserting ...

Get The Language of SQL, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.