db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

BEFORE trigger

A BEFORE ROW trigger can change the row before it is stored: assign to NEW and return it. The trigger function is written first, the trigger binds it to the table.

task

Set updated_at on every UPDATE of tk (BEFORE trigger), then update row 1.

hints