258. Updating records

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 created_at column:

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:

Please,...