sqlite trigger to update row modifyDateTime

علی ذوالفقار
1402/10/26 22:21:33 (63)
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