Re: Maintaing a Last updated timestamp column usin g triggers
"Ling, Andy" <[email protected]> Thu, 12 Mar 2020 16:16:22 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
PlRoYW5rcyBBbmR5DQoNCj4+IEluIGFkZGl0aW9uLCB0aGUgcm9sZSBvZiB0aGUgIndoZW4iIGNs YXVzZSBpcyB1bmNsZWFyLiAgSXMgaXQgbmVjZXNzYXJ5Pw0KPj4NCj4+IEkgZG9uJ3QgdGhpbmsg aXQgaXMuIEkgaGF2ZSBhIHZlcnkgc2ltaWxhciB0cmlnZ2VyIHdoaWNoIEkndmUgYmVlbiANCj4+ IHVzaW5nIGZvciBzZXZlcmFsIHllYXJzIEFuZCBpdCBkb2Vzbid0IGhhdmUgdGhlIHdoZXJlLi4u DQo+Pg0KPj4gQ1JFQVRFIFRSSUdHRVIgW1VwZGF0ZVBvcnRUaW1lXSBBRlRFUiBVUERBVEUgT04g cG9ydHMgIEZPUiBFQUNIIFJPVyAgDQo+PiBCRUdJTg0KPj4gICAgVVBEQVRFIHBvcnRzIFNFVCB0 aW1lb2ZkYXkgPSBDVVJSRU5UX1RJTUVTVEFNUCBXSEVSRSBpZCA9IE5FVy5pZCA7ICANCj4+IEVO RA0KPj4NCg0KPldoYXQgc3RvcHMgdGhlDQo+VVBEQVRFIHBvcnRzIFNFVCB0aW1lb2ZkYXkgPSBD VVJSRU5UX1RJTUVTVEFNUCBXSEVSRSBpZCA9IE5FVy5pZCA7IGZyb20gYWxzbyB0cmlnZ2VyaW5n IHRoZSBBRlRFUiBVUERBVEUgT04gcmVjdXJzaXZlbHk/DQoNCj5QZXJoYXBzIGEgcHJhZ21hIG9y IGluU1FMaXRlIGFyZSAgdHJpZ2dlcnMgbm9uLXJlY3Vyc2l2ZSBieSBkZWZhdWx0Pw0KDQpJdCBs b29rcyBsaWtlIHRoaXMgYW5zd2VycyB5b3VyIHF1ZXN0aW9uLi4uDQoNCmh0dHBzOi8vc3RhY2tv dmVyZmxvdy5jb20vcXVlc3Rpb25zLzIxMjIzNDM0L2RvLXNxbGl0ZS10cmlnZ2Vycy10cmlnZ2Vy LW90aGVyLXRyaWdnZXJzDQoNCkFuZHkgTGluZw0KDQoNCgoqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqCkRJU0NMQUlN RVI6ClByaXZpbGVnZWQgYW5kL29yIENvbmZpZGVudGlhbCBpbmZvcm1hdGlvbiBtYXkgYmUgY29u dGFpbmVkIGluIHRoaXMgbWVzc2FnZS4gSWYgeW91IGFyZSBub3QgdGhlIGFkZHJlc3NlZSBvZiB0 aGlzIG1lc3NhZ2UsIHlvdSBtYXkgbm90IGNvcHksIHVzZSBvciBkZWxpdmVyIHRoaXMgbWVzc2Fn ZSB0byBhbnlvbmUuIEluIHN1Y2ggZXZlbnQsIHlvdSBzaG91bGQgZGVzdHJveSB0aGUgbWVzc2Fn ZSBhbmQga2luZGx5IG5vdGlmeSB0aGUgc2VuZGVyIGJ5IHJlcGx5IGUtbWFpbC4gSXQgaXMgdW5k ZXJzdG9vZCB0aGF0IG9waW5pb25zIG9yIGNvbmNsdXNpb25zIHRoYXQgZG8gbm90IHJlbGF0ZSB0 byB0aGUgb2ZmaWNpYWwgYnVzaW5lc3Mgb2YgdGhlIGNvbXBhbnkgYXJlIG5laXRoZXIgZ2l2ZW4g bm9yIGVuZG9yc2VkIGJ5IHRoZSBjb21wYW55LiBUaGFuayBZb3UuCl9fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCnNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QK c3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCmh0dHA6Ly9tYWlsaW5nbGlzdHMu c3FsaXRlLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3FsaXRlLXVzZXJzCg==