Re: Table timestamps? More specific control of "SHOW TABLE STATUS" command
Why don't you : select timestampfield from mytable order timestampfield decs limit 1 Jay Lawrence wrote: > > Atle, your suggestion is for the last time a record was updated. I am > interested in the entire table. > > The closest that I have seen thus far is: > SHOW TABLE STATUS > The Update_time field is most likely what I am after. > > However I was hoping to do something more like > > select Update_time from table(x) status > > Giving me one value back - the Update_time for table "x" of current > database. > > Perhaps this is a candidate for function extension? > > Jay > > > You might be able to use this, depending on your needs: > > > > from http://www.mysql.com/doc/D/A/DATETIME.html > > > > [snip] > > Automatic updating of the first TIMESTAMP column occurs under any of the > > following conditions: > > The column is not specified explicitly in an INSERT or LOAD DATA INFILE > > statement. > > The column is not specified explicitly in an UPDATE statement and some > > other column changes value. (Note that an UPDATE that sets a column to the > > value it already has will not cause the TIMESTAMP column to be updated, > > because if you set a column to its current value, MySQL ignores the update > > for efficiency.) > > You explicitly set the TIMESTAMP column to NULL. > > [/snip] > > > > > > .. Atle > > > > On Wed, 14 Feb 2001, Jay Lawrence wrote: > > > > > Hey all, > > > > > > Is there a way to quickly obtain the last time a table was > updated/touched? > > > > > > In my app I am caching queries so long as the table data has not > changed. I'd like a quick check to see if a table has changed since the > query was first executed. My perusal of documentation plus a few searches on > mailing lists has not uncovered this matter - but I could have missed it. > > > > > > TIA, > > > Jay > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table timestamps? More specific control of "SHOW TABLE STATUS"command
On Thu, 15 Feb 2001, Jay Lawrence wrote: > Atle, your suggestion is for the last time a record was updated. I am > interested in the entire table. A temporary workaround could be select max(timestamp) from sometable. Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table timestamps? More specific control of "SHOW TABLE STATUS" command
Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. The closest that I have seen thus far is: SHOW TABLE STATUS The Update_time field is most likely what I am after. However I was hoping to do something more like select Update_time from table(x) status Giving me one value back - the Update_time for table "x" of current database. Perhaps this is a candidate for function extension? Jay > You might be able to use this, depending on your needs: > > from http://www.mysql.com/doc/D/A/DATETIME.html > > [snip] > Automatic updating of the first TIMESTAMP column occurs under any of the > following conditions: > The column is not specified explicitly in an INSERT or LOAD DATA INFILE > statement. > The column is not specified explicitly in an UPDATE statement and some > other column changes value. (Note that an UPDATE that sets a column to the > value it already has will not cause the TIMESTAMP column to be updated, > because if you set a column to its current value, MySQL ignores the update > for efficiency.) > You explicitly set the TIMESTAMP column to NULL. > [/snip] > > > .. Atle > > On Wed, 14 Feb 2001, Jay Lawrence wrote: > > > Hey all, > > > > Is there a way to quickly obtain the last time a table was updated/touched? > > > > In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searches on mailing lists has not uncovered this matter - but I could have missed it. > > > > TIA, > > Jay > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php