Does SQLite store the lastmodified date of a row, like a file system?
If not, how can I do it?
views:
29answers:
2
+3
A:
I think that you can only add column to your table and create trigger for updating column value with datetime('now');
skyman
2010-02-11 23:04:42
That's what I'd try to do too. See http://www.shokhirev.com/nikolai/abc/sql/triggers.html for an example for `insert`; you have to add a similar trigger for `update` too. (untested)
bart
2010-02-12 00:51:03
+1
A:
No.
Add a lastmodified column to your table(s), and update it on modification of that row.
Roger Pate
2010-02-11 23:04:54