Seagull

Lesson 8 - 8. 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.