Schalk <[EMAIL PROTECTED]> wrote on 09/14/2005 09:31:23 AM: > Greetings > > Is there a way to get the last update date for an entire table not just > a single row? More specifically, is there a way to do this with Java? > > -- > Kind Regards > Schalk Neethling > Web Developer.Designer.Programmer.President > Volume4.Business.Solution.Developers >
METHOD A: SHOW TABLE STATUS -- look for the column "UPDATE TIME" METHOD B: If the table has any column defined as type TIMESTAMP, do: SELECT MAX(first_timestamp_column) from tablename; METHOD C (MyISAM or INNODB with file-per-table): Use OS functions to get the value of the "last modification" datetime from the data file itself. I am sure there are others.... Shawn Green Database Administrator Unimin Corporation - Spruce Pine
