Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    56

    Unanswered: "update_time" for innodb

    Hello,
    does anyone know how to get table "update_time" using innodb engine?

    Thanks,
    David

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think you just need to query the information_schema.tables
    MySQL :: MySQL 5.0 Reference Manual :: 19.2 The INFORMATION_SCHEMA TABLES Table
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    I'm 99.9% sure that valule doesn't exist in Innodb.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by scottb View Post
    I'm 99.9% sure that valule doesn't exist in Innodb.
    i think the original poster was asking about retrieving a timestamp for when the last update was made to the table

    george answered it as though it was a question about whether "update_time" was a column in the table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2009
    Posts
    56
    In the MySQL "information_schema" database is a table called "TABLES" and it has a "UPDATE_TIME" column for each table in all databases on the given s MySQL server.

    For MyISAM tables the "UPDATE_TIME" field is updated every time a change to the given table is made, for InnoDB tables the value for "UPDATE_TIME" is always NULL.

    Maybe someone knows if there is a patch, so InnoDB tables get their "UPDATE_TIME" value updated as well.

    Thanks,
    David

Posting Permissions

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