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
精彩评论