Re: Maintaing a Last updated timestamp column using triggers
David Raymond <[email protected]> Thu, 12 Mar 2020 16:31:31 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1PR07MB60298A226129D67A0A0D163B87FD0@VI1PR07MB6029.eurprd07.prod.outlook.com> |
PiBXaGF0IHN0b3BzIHRoZQ0KPiBVUERBVEUgcG9ydHMgU0VUIHRpbWVvZmRheSA9IENVUlJFTlRf VElNRVNUQU1QIFdIRVJFIGlkID0gTkVXLmlkIDsNCj4gZnJvbSBhbHNvIHRyaWdnZXJpbmcgdGhl IEFGVEVSIFVQREFURSBPTiByZWN1cnNpdmVseT8NCj4gDQo+IFBlcmhhcHMgYSBwcmFnbWEgb3Ig aW5TUUxpdGUgYXJlICB0cmlnZ2VycyBub24tcmVjdXJzaXZlIGJ5IGRlZmF1bHQ/DQo+IA0KPiBJ IGFtIHVzaW5nIChub3cgSSBoYXZlIGJ5IHNlbWktY29sb25zIHJpZ2h0KQ0KPiBDUkVBVEUgVFJJ R0dFUiB0Z3JVcGRhdGUgQUZURVIgVVBEQVRFIE9OIG15VGFibGUgRk9SIEVBQ0ggUk9XDQo+IFdI RU4gTkVXLkxhc3RVcGRhdGUgPD0gT0xELiBMYXN0VXBkYXRlDQo+IEJFR0lODQo+IFVQREFURSBt eVRhYmxlIFNFVCAgTGFzdFVwZGF0ZSA9IERBVEVUSU1FKCdub3cnKSBXSEVSRSBpZCA9IE9MRC5p ZDsNCj4gRU5EDQo+IA0KPiBNeSBpbnRlbnRpb24gaXMgZm9yIHRoZSB3aGVuIHRvIGF2b2lkIGlu ZmluaXRlIGNhbGxzLCBidXQgbWF5YmUgSSBhbQ0KPiBmb29saW5nIG15c2VsZi4NCg0KUmVjdXJz aXZlIHRyaWdnZXJzIGFyZSBvZmYgYnkgZGVmYXVsdC4NCk90aGVyd2lzZSB5b3UgY291bGQgYWx3 YXlzIGFkZCBjaGVja3MgaW50byB0aGUgV0hFTiBjbGF1c2UgZm9yIHNlZWluZyBpZiBhbnkgb2Yg dGhlIG90aGVyIGZpZWxkcyB3YXMgYWN0dWFsbHkgdXBkYXRlZC4NCg0KV0hFTiBORVcuTGFzdFVw ZGF0ZSA8PSBPTEQuTGFzdFVwZGF0ZQ0KICAgICBBTkQNCiAgICAgKCAgIC0tU29tZXRoaW5nIGFj dHVhbGx5IGNoYW5nZWQNCiAgICAgICAgIE5FVy5GaWVsZDEgaXMgbm90IE9MRC5GaWVsZDENCiAg ICAgICAgIE9SDQogICAgICAgICBORVcuRmllbGQyIGlzIG5vdCBPTEQuRmllbGQyDQogICAgICAg ICBPUiAuLi4NCiAgICAgICAgIC0tVGhpbmsgeW91IHdhbnQgdG8gZXhjbHVkZSBMYXN0VXBkYXRl IGZyb20gdGhpcyBPUidkIGxpc3Qgb2YgY2hhbmdlZCBmaWVsZHMgdG8gY2hlY2sNCiAgICAgKQ0K DQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUt dXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpo dHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3Nx bGl0ZS11c2Vycwo=