SQLite trigger. Mostly for ON UPDATE, actually.
CREATE TRIGGER IF NOT EXISTS deck_on_update AFTER UPDATE ON deck WHEN OLD.date_created <> NEW.date_created BEGIN UPDATE deck SET date_updated = strftime('%Y-%m-%dT%H:%M:%fZ', 'now') WHERE [uid] = NEW.uid; END;
Also, better SQLite CURRENT_TIMESTAMP, to be inline with JavaScript's new Date().toISOString().
CURRENT_TIMESTAMP
new Date().toISOString()
date_created TEXT DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
I have never created a TRIGGER ini SQL
TRIGGER
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
SQLite trigger. Mostly for ON UPDATE, actually.
Also, better SQLite
CURRENT_TIMESTAMP
, to be inline with JavaScript'snew Date().toISOString()
.I have never created a
TRIGGER
ini SQL