Seagull

Lesson 8 - 10. AFTER DELETE Trigger on Users

Dataset statusDemo datasetvv1

Exercise content

Create the tables users and logs.

Then create an AFTER DELETE trigger that records in logs:

user_id
old_email
old_phone
action
created_at

The fields new_email and new_phone must remain NULL.

Hints

Hint 1
The trigger works on users, but writes into logs. So both tables must exist.
Hint 2
When a row is deleted, you can read the previous values with OLD. For this exercise you need the old id, email, and phone.
Hint 3
Create an AFTER DELETE trigger that does an INSERT INTO logs. The new_email and new_phone fields must remain NULL.

Not completed

Loading dataset...

Latest result

No result set available.