Re: Maintaing a Last updated timestamp column using triggers
David Raymond <[email protected]> Thu, 12 Mar 2020 18:22:12 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1PR07MB6029A7A8369B3CAE24A3F11387FD0@VI1PR07MB6029.eurprd07.prod.outlook.com> |
PiBBbHRlcm5hdGl2ZWx5LCB5b3UgY2FuIHVzZSB0aGUgbmV3IEdFTkVSQVRFRCBBTFdBWVMgQVMg KC4uLikgU1RPUkVEIHRvIG1ha2UgaXQgYW4gYXV0b21hdGljYWxseSB1cGRhdGVkIHN0b3JlZCBm aWVsZCBhbmQgeW91IGRvIG5vdCBuZWVkIHRyaWdnZXJzIGF0IGFsbCwganVzdCBhIHZlcnNpb24g b2YgU1FMaXRlMyB0aGF0IGRvZXMgZ2VuZXJhdGVkIGNvbHVtbnMgKHZlcnNpb24gMy4zMS4wIGZy b20gMjAyMC0wMS0yMiBvciBsYXRlcikuDQo+IA0KPiBjcmVhdGUgdGFibGUgTXlEYXRhDQo+ICgN Cj4gICBpZCAgIGludGVnZXIgcHJpbWFyeSBrZXksDQo+ICAgZGF0YSwNCj4gICBsYXN0dXBkYXRl IHJlYWwgYXMgKGp1bGlhbmRheSgpKSBzdG9yZWQNCj4gKTsNCg0KSSB0aG91Z2h0IHRoYXQgZ2Vu ZXJhdGVkIGNvbHVtbnMgY291bGQgb25seSB1c2UgZGV0ZXJtaW5pc3RpYyBmdW5jdGlvbnM/DQpo dHRwczovL3d3dy5zcWxpdGUub3JnL2dlbmNvbC5odG1sDQoiMi4zLiBMaW1pdGF0aW9ucw0KLi4u DQozLiBUaGUgZXhwcmVzc2lvbiBvZiBhIGdlbmVyYXRlZCBjb2x1bW4gbWF5IG9ubHkgcmVmZXJl bmNlIGNvbnN0YW50IGxpdGVyYWxzIGFuZCBjb2x1bW5zIHdpdGhpbiB0aGUgc2FtZSByb3csIGFu ZCBtYXkgb25seSB1c2Ugc2NhbGFyIGRldGVybWluaXN0aWMgZnVuY3Rpb25zLiBUaGUgZXhwcmVz c2lvbiBtYXkgbm90IHVzZSBzdWJxdWVyaWVzLCBhZ2dyZWdhdGUgZnVuY3Rpb25zLCB3aW5kb3cg ZnVuY3Rpb25zLCBvciB0YWJsZS12YWx1ZWQgZnVuY3Rpb25zLg0KLi4uIg0KDQoNCmh0dHBzOi8v d3d3LnNxbGl0ZS5vcmcvZGV0ZXJtaW5pc3RpYy5odG1sDQoiMy4gU3BlY2lhbC1jYXNlIFByb2Nl c3NpbmcgRm9yIERhdGUvVGltZSBGdW5jdGlvbnMNCg0KVGhlIGJ1aWx0LWluIGRhdGUgYW5kIHRp bWUgZnVuY3Rpb25zIG9mIFNRTGl0ZSBhcmUgYSBzcGVjaWFsIGNhc2UuIFRoZXNlIGZ1bmN0aW9u cyBhcmUgdXN1YWxseSBjb25zaWRlcmVkIGRldGVybWluaXN0aWMuIEhvd2V2ZXIsIGlmIHRoZXNl IGZ1bmN0aW9ucyB1c2UgdGhlIHN0cmluZyAibm93IiBhcyB0aGUgZGF0ZSwgb3IgaWYgdGhleSB1 c2UgdGhlIGxvY2FsdGltZSBtb2RpZmllciBvciB0aGUgdXRjIG1vZGlmaWVyLCB0aGVuIHRoZXkg YXJlIGNvbnNpZGVyZWQgbm9uLWRldGVybWluaXN0aWMuIEJlY2F1c2UgdGhlIGZ1bmN0aW9uIGlu cHV0cyBhcmUgbm90IG5lY2Vzc2FyaWx5IGtub3duIHVudGlsIHJ1bi10aW1lLCB0aGUgZGF0ZS90 aW1lIGZ1bmN0aW9ucyB3aWxsIHRocm93IGFuIGV4Y2VwdGlvbiBpZiB0aGV5IGVuY291bnRlciBh bnkgb2YgdGhlIG5vbi1kZXRlcm1pbmlzdGljIGZlYXR1cmVzIGluIGEgY29udGV4dCB3aGVyZSBv bmx5IGRldGVybWluaXN0aWMgZnVuY3Rpb25zIGFyZSBhbGxvd2VkLiINCg0KDQpTbyBpcyAianVs aWFuZGF5KCdub3cnKSIgbm9uLWRldGVybWluaXN0aWMgd2hpbGUgImp1bGlhbmRheSgpIiBfaXNf IGRldGVybWluaXN0aWM/IFRoYXQgc2VlbXMgYSBsaXR0bGUgd2VpcmQgY29uc2lkZXJpbmcgdGhl eSdyZSB0aGUgc2FtZSB0aGluZy4uLiByaWdodD8NCg0KX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUt dXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUu b3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK