CODEWITHSUNDEEP
phpsqlite
Variant
Variant

Reputation: 17385

Check when an SQLite database/table was last updated (PHP)

Is there any way to check when an SQLite db was last updated?
Alternatively is there any way to do it for a specific table?

Since SQLite is a file based db I guess I can look at the date on the file but I am not sure I can rely on that.

Upvotes: 3

Views: 6183

Answers (2)

Yoshi
Yoshi

Reputation: 103

I believe this could be achieved by SQLite TRIGGERS

Upvotes: 1

James
James

Reputation: 474

I know this is an old post but in case someone else reads this please see this post:

Android check when table was last updated

Upvotes: 2

Related Questions