Is there anyway I can get the last updated time of a set of tables? By last updated time, I mean not only when the table's schema changed but when any of the rows changed or even when rows were created/deleted in the given set of tables.
I tried both
SELECT * FROM information_schema.tables and
SHOW TABLE STATUS FROM myDb and I only see the
create_time which is only when table was created.
I can alternatively create triggers like:
CREATE TRIGGER tbl1_delete AFTER DELETE ON tbl1 FOR EACH ROW BEGIN UPDATE table_updates SET update_time = now() WHERE table_name = tbl1 END
But, now I have to repeat this over and over for deletes, updates, creations and schema changes. And, I want to automate this for all my tables!