how do you create triggers in D1? i cant get mine to work. it says ` incomplete input [code: 7500]`
how do you create triggers in D1? i cant get mine to work. it says
incomplete input [code: 7500]CREATE TRIGGER update_channels_updatedAt
AFTER UPDATE ON channels
FOR EACH ROW
BEGIN
UPDATE channels SET updatedAt = CURRENT_TIMESTAMP WHERE _id = NEW._id;
END;