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,...
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 