db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Statement trigger

A statement trigger fires once per statement. REFERENCING NEW TABLE gives it all the new rows as a table. Two statements: three rows, then one.

task

Log how many rows each INSERT statement added to bk, with a transition table, then insert 3 rows in one statement and 1 row in another.

hints