Seagul

Lesson 10 - UPDATE Trigger for Email and Phone

Dataset statusDemo datasetvv1

Exercise content

Create the tables users and logs.

Then create an AFTER UPDATE trigger that records in logs:

user_id
old_email, new_email
old_phone, new_phone
action
created_at

If a field does not change, the corresponding value in the log can be NULL.

Hints

Hint 1

First create users and logs with the required columns. Also insert at least one user into users, otherwise the trigger will have nothing to track.
Hint 2

You need an AFTER UPDATE trigger on users. You can limit it to the email and phone fields with UPDATE OF ....
Hint 3

Inside BEGIN ... END, insert a row into logs using OLD and NEW. If a field does not change, save NULL with a CASE WHEN.

Not completed

Loading dataset...

Latest result

No result set available.