Database Reference
In-Depth Information
Even though we did not explicitly provide a value for the second component of
alice
's
education, the previous value of
2003
was overwritten with a
null
value by our last up-
date. This observation serves to emphasize the
frozen
nature of tuples: any time we up-
date any part of a tuple, we update the entire thing.
Before we move on, let's restore
alice
's education column to its previous state:
UPDATE "users"
SET "education" = ('Big Data University', 2003)
WHERE "username" = 'alice';