← Back to Posts

sqlite trigger to update row modifyDateTime

👤 علی ذوالفقار 📅 1402/10/26 22:21:33 👁️ 244 views
DROP TRIGGER "main"."trg_udate";

CREATE TRIGGER "main"."trg_udate"
AFTER UPDATE
ON "tbl_test"
BEGIN
	UPDATE tbl_test set udate = datetime('now','localtime') where id = old.id ;
END;
← Back to Posts