sqlite trigger to update row modifyDateTime
علی ذوالفقار
1402/10/26 22:21:33 (215)
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;