Re: Maintaing a Last updated timestamp column using triggers
Clemens Ladisch <clemens-P6GI/[email protected]> Thu, 12 Mar 2020 09:03:46 +0100
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
RGF2aWQgQmxha2Ugd3JvdGU6Cj4gQ1JFQVRFIFRSSUdHRVIgbXlfdXBkYXRlX3RyaWdnZXIgQkVG T1JFIFVQREFURSBPTiAgTXlfdGFibGUKPiAgIEZPUiBFQUNIIFJPVyBXSEVOIE5FVy5sYXN0dXBk YXRlZCA8IE9MRC4gbGFzdHVwZGF0ZWQKPiAgIEJFR0lOCj4gICAgICAgVVBEQVRFIHNvbmcgU0VU ICBsYXN0dXBkYXRlZCA9IERBVEVUSU1FKCdub3cnKSBXSEVSRSBpZCA9IE5FVy5pZAo+ICAgRU5E Cj4KPiBUaGUgV0hFTiBjbGF1c2UgaXMgYW4gYXR0ZW1wdCB0byBhdm9pZCBpbmZpbml0ZSByZWN1 cnNpb24gdGhhdCBVUERBVEUKPiB3aXRoaW4gYW4gVVBEQVRFIHdvdWxkIGNhdXNlLgoKVHlwaWNh bCBVUERBVEUgc3RhdGVtZW50cyB3aWxsIGxlYXZlIHRoaXMgZmllbGQgd2l0aCBpdHMgb2xkIHZh bHVlLCBzbwppdCBtaWdodCBiZSBhIGJldHRlciBpZGVhcyB0byB1c2UgPD0gaW5zdGVhZCBvZiA8 LgoKPiBIb3dldmVyIEkgZ2V0IFNRTCBlcnJvcnMgd2hlbiBJIHRyeSBkZWZpbmluZyBhIHRyaWdn ZXIgdGhpcyB3YXkgdGhpcwo+IGluIG15IGZhdm9yaXRlIGRiIGRicm93c2VyLgoKVGhhbmsgeW91 IHZlcnkgbXVjaCBmb3Iga2VlcGluZyB0aGUgZXJyb3IgbWVzc2FnZSBzZWNyZXQuCgpXaGVuIEkg Zml4IHRoZSB3cm9uZyB0YWJsZSB0YWJsZSBuYW1lIGFuZCBhZGQgdGhlIG1pc3Npbmcgc2VtaWNv bG9uIGFmdGVyCnRoZSBVUERBVEUgc3RhdGVtZW50LCB0aGlzIHRyaWdnZXIgd29ya3MgZmluZS4K CgpSZWdhcmRzLApDbGVtZW5zCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fCnNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QKc3FsaXRlLXVzZXJzQG1haWxpbmds aXN0cy5zcWxpdGUub3JnCmh0dHA6Ly9tYWlsaW5nbGlzdHMuc3FsaXRlLm9yZy9jZ2ktYmluL21h aWxtYW4vbGlzdGluZm8vc3FsaXRlLXVzZXJzCg==