SQLite 笔记

查版本：

SELECT sqlite_version();

UPDATE 自动更新日期时间：

BEGIN UPDATE category SET uTime = datetime('now', 'localtime') WHERE id=OLD.id; END

[STARTVCODE]ae468bf3aceb74e8ee0326f20a8bebf448996ed90e73482b153cca7f830945e4f0845331027f52ae5bab1783833ca9096da234b2b74603309f994fbae7ed5632f48d08ff46b83b06020e24d79fb25aa8c61cdcf58ca3c2b51edfb24fd590e5bc78d01063143ebe05a55fd8f9d5359e94df7fccdd22e1c833b13d281136869e5f8ff7ebcba32d18e35b7bec140c51e22eb2b6cbae7df2fe521d5d90feda7098b0b8c77424533462a294a98df59eafab93940fab3851e4eb63c0037e7b21aa2f539c66edf199d5d937e96c108eef6b05c7db66537fdf028a10663a888e76c42c590a94a33e5ca25b2126353778df2a37b1c422b8278f0d2745e90b8e3277eb21cf9e4d3e419b7e25090e60b360c56a45f7e9be359a7bb343cb06a2dd58cb04b810a36823240893fdaf0931506f6606bfc4ebb3b724f0c1c78b66026e9339ae7da8cae89786004425629b1c354429dfaf659913bbe7e6185c37739142c71fb5291258aab842bcd8e3c920da3ded920ae94fbf6abcd94ed976242eca15d007449d9c8e56d691fef91191bf3ad689a8a15e8624e4bafc2da8420a658337aee2f8ce14e2fddacaca4704cd8099ccb47a049db085120fbec5b2184216f1361c6a636b62ce8786b6ff7d40d0cf3ab78b57688581089b1b3fbdf3fcd5c315de003e7eddb4577158153452fb6fc16e719dd93202da4eae1b713bff9310a0b3d60c2159fc93a6afeea0651cd7693f23821b0c71627ce21bdfb443eed3a21885723e6a96cd206fde61f3eacf53fe08d238a13cae79b1f97e51c01eae070e8fe95d9876c3e3a7f26554795b32c1507f0c36148abee6db5695054748f1d9264183f03c9cc807f37eeb2bbc234b9e842b59395d4c0435ddc85e44ba5d6d3706829614e9dc372a91c14c2c6428672755dfc4bb54d4c811f0c06e094acd3e84b530d35b0f7a57876451776d95a14e0b572c0e2b24c50e3117c6c3883fb601f4990ce4bfbc4d70fa2b6a2544281464b193695ef4f5642fd4474cae678ca274e50653a4b89022eb11dda984b9bde95c97eae50d22caf8f3c64f5edc17e346124502d46e69c1384c5ad3da2bd0d479a2ff78e980fe41f8e4ef917d8175ae765b9309bf8326116971035a7615b5545b0e2ebddf4cfa9c2782007c09857e74c97fd6d8e374ad482b40ba738834dc176b9b2d1e0e93368cafbc7e2fef5ff0c4993167085ec685877264d5f7e90aaba6efc5703be69a40e70f0f3b57958838a9acbf4e87ebf088574f26014d9ba8c800ac593c51ef4923555374e14dc2acb1088d9a73aaa3d69bf62ff5d95856b7271d93bf66939a36ba9d78b5b02ae22e30f21f8439689f90aed4d535cb21188bce8e925bbca6f401731c92ab0d29c83f2641a3aea532986927884092dd495fec275050d779e515d98eccced166c948138973237bf08fb9294ccd043fe0b3[ENDVCODE]

[stcode]8ceea80f23544ac3d56860ff4268d098dbf4a36441a0304d28f427c132315a61d5321f99e19fd6f06904497102a19e63af5d9f8ea5cea9e391362ac4fd0dba26f54abf1f8379c6ec1a78efe8985a9b08ece9d069a1d1483292c53f2bc8f85aa5580d5d51e685f0d131641dc0152fd568403db080f6d8250472f8a22f6ad0b20be6d8e242ff8e817227e4feb633486ec75706dfe3ffad37f7f8ebc6f0149b5cb8[edcode]

BEGIN UPDATE category SET uTime = datetime('now', 'localtime') WHERE id=OLD.id; END