Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    4

    Unanswered: query to know when table has been updated or values have been inserted

    Hi,
    I want to know when table has been updated or values have been inserted because the table is one year old so i need to do R&D over there.

    Thanks in advance!!!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    consider putting a timestamp column in the relevant table(s)
    then query that column
    or
    put a date created column ( a datetime) and a last edited column (timestamp), then qwuery the difference using the MySQL date time functions
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •