sqlite_action

 

CREATE TRIGGER https://www.sqlite.org/lang_createtrigger.html

 

触发器

DROP TABLE IF EXISTS user_token;
CREATE TABLE IF NOT EXISTS user_token (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
token TEXT NULL,
"uid" INTEGER NULL,
"cid" INTEGER NULL,
"info" TEXT NULL,
created_at TEXT NOT NULL DEFAULT (DATETIME('now', 'localtime')),
updated_at TEXT NOT NULL DEFAULT (DATETIME('now', 'localtime'))
)
;
CREATE TRIGGER IF NOT EXISTS trigger_user_token_updated_at AFTER UPDATE ON user_token
BEGIN
UPDATE user_token SET updated_at = DATETIME('now', 'localtime')
WHERE rowid = NEW.rowid;
END;

 通过触发器 自动更新时间 

 

 SQLite 触发器 | 菜鸟教程 https://www.runoob.com/sqlite/sqlite-trigger.html

 sqlite3自动插入创建时间和更新时间 - wang_yb - 博客园 https://www.cnblogs.com/wang_yb/p/18239784

 

 

 

翻译

搜索

复制