Seagul

Lesson 10 - Update updated_at with a trigger

Dataset statusDemo datasetvv1

Exercise content

Prepare a users table that also includes the updated_at column.

Then create a trigger on the users table that automatically updates updated_at every time a row is modified with an UPDATE.

Hints

Hint 1

The users table must also have updated_at. The trigger will update exactly that field.
Hint 2

It is not needed on insert or delete. Here the correct moment is when a row is modified.
Hint 3

Inside the trigger body, update the same row with the current timestamp. The goal is to have updated_at filled after an UPDATE.

Not completed

Loading dataset...

Latest result

No result set available.