CREATE TABLE test ( test TEXT, created_at TEXT NOT NULL DEFAULT (DATETIME('now', 'localtime')), updated_at TEXT NOT NULL DEFAULT (DATETIME('now', 'localtime')) ); CREATE TRIGGER trigger_test_updated_at AFTER UPDATE ON test BEGIN UPDATE test SET updated_at = DATETIME('now', 'localtime') WHERE rowid == NEW.rowid; END; ãã¼ãã«åãããªã¬ã¼åã® test ã®é¨åãå¿ è¦ã«å¿ãã¦æ¸ãæãã¦ãã ããã 2. 説æ 2.1. DEFAULT å¶ç´ã§ DATETIME 颿°ã使ãã ãDEF


{{#tags}}- {{label}}
{{/tags}}