Re: Maintaing a Last updated timestamp column using triggers
David Blake <[email protected]> Thu, 12 Mar 2020 08:18:19 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAHdQWy3owzKxe8JKrNWLZpfUoOtK9jefZTLwtqKBASREL22Hrw@mail.gmail.com> |
VGhhbmtzIGZvciBzdWNoIGEgc3dpZnQgcmVwbHksIGdvb2QgdG8ga25vdyB0aGF0IGl0IHNob3Vs ZCB3b3JrICh3aXRob3V0CnR5cG9zKQoKPlRoYW5rIHlvdSB2ZXJ5IG11Y2ggZm9yIGtlZXBpbmcg dGhlIGVycm9yIG1lc3NhZ2Ugc2VjcmV0LgoKbmVhciAiRU5EIjogc3ludGF4IGVycm9yOgoKCkkn bSB0ZXN0aW5nIG91dCBpZGVhcyB1c2luZyBEQiBCcm93c2VyLCBidXQgd2lsbCB0cnkgaW4gbXkg YXBwIGFuZCBzZWUgaWYKdGhpcyBpcyBqdXN0IGEgREIgQnJvd3NlciBpc3N1ZQoKT24gVGh1LCAx MiBNYXIgMjAyMCBhdCAwODowNCwgQ2xlbWVucyBMYWRpc2NoIDxjbGVtZW5zQGxhZGlzY2guZGU+ IHdyb3RlOgoKPiBEYXZpZCBCbGFrZSB3cm90ZToKPiA+IENSRUFURSBUUklHR0VSIG15X3VwZGF0 ZV90cmlnZ2VyIEJFRk9SRSBVUERBVEUgT04gIE15X3RhYmxlCj4gPiAgIEZPUiBFQUNIIFJPVyBX SEVOIE5FVy5sYXN0dXBkYXRlZCA8IE9MRC4gbGFzdHVwZGF0ZWQKPiA+ICAgQkVHSU4KPiA+ICAg ICAgIFVQREFURSBteV90YWJsZVNFVCAgbGFzdHVwZGF0ZWQgPSBEQVRFVElNRSgnbm93JykgV0hF UkUgaWQgPSBORVcuaWQKPiA+ICAgRU5ECj4gPgo+ID4gVGhlIFdIRU4gY2xhdXNlIGlzIGFuIGF0 dGVtcHQgdG8gYXZvaWQgaW5maW5pdGUgcmVjdXJzaW9uIHRoYXQgVVBEQVRFCj4gPiB3aXRoaW4g YW4gVVBEQVRFIHdvdWxkIGNhdXNlLgo+Cj4gVHlwaWNhbCBVUERBVEUgc3RhdGVtZW50cyB3aWxs IGxlYXZlIHRoaXMgZmllbGQgd2l0aCBpdHMgb2xkIHZhbHVlLCBzbwo+IGl0IG1pZ2h0IGJlIGEg YmV0dGVyIGlkZWFzIHRvIHVzZSA8PSBpbnN0ZWFkIG9mIDwuCj4KPiA+IEhvd2V2ZXIgSSBnZXQg U1FMIGVycm9ycyB3aGVuIEkgdHJ5IGRlZmluaW5nIGEgdHJpZ2dlciB0aGlzIHdheSB0aGlzCj4g PiBpbiBteSBmYXZvcml0ZSBkYiBkYnJvd3Nlci4KPgo+IFRoYW5rIHlvdSB2ZXJ5IG11Y2ggZm9y IGtlZXBpbmcgdGhlIGVycm9yIG1lc3NhZ2Ugc2VjcmV0Lgo+Cj4gV2hlbiBJIGZpeCB0aGUgd3Jv bmcgdGFibGUgdGFibGUgbmFtZSBhbmQgYWRkIHRoZSBtaXNzaW5nIHNlbWljb2xvbiBhZnRlcgo+ IHRoZSBVUERBVEUgc3RhdGVtZW50LCB0aGlzIHRyaWdnZXIgd29ya3MgZmluZS4KPgo+Cj4gUmVn YXJkcywKPiBDbGVtZW5zCj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18KPiBzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0Cj4gc3FsaXRlLXVzZXJzQG1haWxp bmdsaXN0cy5zcWxpdGUub3JnCj4gaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1i aW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMKPgpfX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0 ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0 ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=