[ACCEPTED]-Does SQLite store the lastmodified date of a row?-sqlite

Accepted answer

Score: 12

I think that you can only add column to 2 your table and create trigger for updating 1 column value with datetime('now');

Score: 7

CREATE TABLE "appInfo" (bundle_id text NOT NULL PRIMARY KEY,appname text,title text DEFAULT appname,display_image text DEFAULT "default.gif",full_size_image text DEFAULT "default.gif",bundle_version text DEFAULT "1.0",company_id text,ipaname text,createdatetime text DEFAULT (strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime')),updatedatetime text DEFAULT (strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime')))

CREATE TRIGGER update_appInfo_updatetime  BEFORE update ON appInfo 
begin
update appinfo set updatedatetime = strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime') where bundle_id = old.bundle_id;
end

Score: 4

No.

Add a lastmodified column to your table(s), and 1 update it on modification of that row.

Source: stackoverflow.com

Python, Sqlite3 - How to convert a list to a BLOB cell

django error 'too many values to unpack'

SQLite parameter substitution and quotes

How to insert duplicate rows in SQLite with a unique ID?

Create SQLite database in memory

How to discover table properties from SQLAlchemy mapped object

How would you convert secs to HH:MM:SS format in SQLite?

Are there any reserved words in SQLite?

Only first table in create table statement being created

Why do I get a "sqlite3: not found" error on a rooted Nexus One when I try to open a database using the adb shell?

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.