美文网首页
mysql修改表后update_time总为null

mysql修改表后update_time总为null

作者: 舒尔诚 | 来源:发表于2019-07-25 10:24 被阅读0次

    费劲力气终于在老外网站上(第二个链接)找到了: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

    相关文章

      网友评论

          本文标题:mysql修改表后update_time总为null

          本文链接:https://www.haomeiwen.com/subject/avycrctx.html