Maintaing a Last updated timestamp column using triggers

David Blake <[email protected]> Thu, 12 Mar 2020 07:47:45 +0000

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<CAHdQWy0dJDx+WH8h6_-AZg-4Grdu-k+BahhG9yjMV3jw_OP1dQ@mail.gmail.com>

SSdtIGxvb2tpbmcgZm9yIGFuIGVhc3kgd2F5IHRvIG1haW50YWluIGEgbGFzdCB1cGRhdGVkIGNv
bHVtbiBmb3IgZWFjaApyZWNvcmQgaW4gc2V2ZXJhbCB0YWJsZXMgYW5kIGNvbnNpZGVyaW5nIGlm
IHVzaW5nIGEgdHJpZ2dlcnMgaXMgdmlhYmxlLgoKSSB0aG91Z2h0IHRoYXQgZGVmaW5pbmcgYSB0
cmlnZ2VyIGxpa2UgdGhpcyBvbiBlYWNoIHRhYmxlIHdvdWxkIHdvcmsKCkNSRUFURSBUUklHR0VS
IG15X3VwZGF0ZV90cmlnZ2VyIEJFRk9SRSBVUERBVEUgT04gIE15X3RhYmxlCiAgRk9SIEVBQ0gg
Uk9XIFdIRU4gTkVXLmxhc3R1cGRhdGVkIDwgT0xELiBsYXN0dXBkYXRlZAogIEJFR0lOCiAgICAg
IFVQREFURSBzb25nIFNFVCAgbGFzdHVwZGF0ZWQgPSBEQVRFVElNRSgnbm93JykgV0hFUkUgaWQg
PSBORVcuaWQKICBFTkQKClRoZSBXSEVOIGNsYXVzZSBpcyBhbiBhdHRlbXB0IHRvIGF2b2lkIGlu
ZmluaXRlIHJlY3Vyc2lvbiB0aGF0IFVQREFURQp3aXRoaW4gYW4gVVBEQVRFIHdvdWxkIGNhdXNl
LiBIb3dldmVyIEkgZ2V0IFNRTCBlcnJvcnMgd2hlbiBJIHRyeSBkZWZpbmluZwphIHRyaWdnZXIg
dGhpcyB3YXkgdGhpcyBpbiBteSBmYXZvcml0ZSBkYiBkYnJvd3Nlci4KCk1heWJlIHVzaW5nIHRy
aWdnZXJzIGZvciB0aGlzIGlzIGZsYXdlZCwgYW5kIEkgc2hvdWxkIGp1c3QgZW5zdXJlIGFsbAp1
cGRhdGUgc3RhdGVtZW50cyBzZXQgdGhlIGNvbHVtbiwgb3IgYW0gSSBtaXNzaW5nIGEgdHJpY2s/
Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCnNxbGl0ZS11
c2VycyBtYWlsaW5nIGxpc3QKc3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCmh0
dHA6Ly9tYWlsaW5nbGlzdHMuc3FsaXRlLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3Fs
aXRlLXVzZXJzCg==