Welcome to the chapter Manipulating data! So far we’ve been talking about
SELECT-ing records and calculating things, usually it takes most of our time working with databases. It’s an ideal scenario when the import of data to the warehouse is fully automated.
There are cases when we need to insert new records manually (a one time import for ad hoc analysis) or update/delete existing records (due to a bug, for example). This is exactly what we’ll be discussing in this chapter!
Let’s start with
INSERT-ing new records into a table.