[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 
update appinfo set updatedatetime = strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime') where bundle_id = old.bundle_id;


Score: 4


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

More Related questions