You may have noticed that the records we inserted in the previous lesson have a lot of empty columns. That could cause a lot of problems in our reporting so let’s update these records in this lesson.
Let’s start with a simple
UPDATE query that sets the value of the
UPDATE users SET created_at = now() WHERE id IN (8391, 8392)
We could also update multiple columns at once:
UPDATE users SET signup_date = created_at::date, status = 'free' WHERE id IN (8391, 8392)
We should see the changes after refreshing the table: