MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Check if a table has been updated
Posted by: Shantanu Oak
Date: August 19, 2005 06:35AM

SHOW TABLE STATUS LIKE 'foo'
Look for Create_time and Update_time
This is the "least resource intensive method" that I can think of.
There must be a better solution.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Check if a table has been updated
Jack Black
August 18, 2005 12:08PM
Re: Check if a table has been updated
Shantanu Oak
August 19, 2005 06:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.