Seagull

Lesson 8 - 9. AFTER INSERT Trigger on Users

Dataset statusDemo datasetvv1

Exercise content

Create the tables users and logs.

Then create an AFTER INSERT trigger that records in logs:

user_id
new_email
new_phone
action
created_at

The fields old_email and old_phone must remain NULL.

Hints

Hint 1
The trigger fires on users but saves the event in logs. Create both before the trigger.
Hint 2
After an insert, the newly created values are available through NEW. Here you mainly care about id, email, and phone.
Hint 3
In the log, the action must be INSERT. The old_email and old_phone fields should be left NULL.

Not completed

Loading dataset...

Latest result

No result set available.