开发者

Logging time stamp of last update for every record

I am using an sqlite3 database in Linux. I want to log the last update time stamp for every recor开发者_如何学Pythond. Can any one suggest me a way to automate this process?


You need to create a table with a timestamp column. Every time you do something to a row in your column, you need to execute an UPDATE statement on that row, such as

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜