You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In line 2, omitting ON makes highlighting work correctly (but is invalid SQL of course).
CREATE TRIGGER IF NOT EXISTS mytrigger
AFTER UPDATE ON accounts
FOR EACH ROW
BEGIN
UPDATE mytable SET mytime = CURRENT_TIMESTAMP WHERE id = OLD.id;
END;
Example:
In line 2, omitting
ONmakes highlighting work correctly (but is invalid SQL of course).Tested in neovim.
Trigger syntax:
https://sqlite.org/lang_createtrigger.html
https://www.postgresql.org/docs/current/sql-createtrigger.html
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html