查询以查找在过去一小时内修改的表 [英] Query to find tables modified in the last hour

问题描述

我想知道在MySQL数据库的最后一小时修改了哪些表。我如何做到这一点？

I want to find out which tables have been modified in the last hour in a MySQL database. How can I do this?

推荐答案

MySQL 5.x可以通过INFORMATION_SCHEMA数据库。此数据库包含有关表，视图，列等的信息。

MySQL 5.x can do this via the INFORMATION_SCHEMA database. This database contains information about tables, views, columns, etc.

SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE DATE_SUB(NOW(), INTERVAL 1 HOUR) < UPDATE_TIME

返回最近一小时内已更新的所有表格（UPDATE_TIME）。您还可以按数据库名称（TABLE_SCHEMA列）过滤。

Returns all tables that have been updated (UPDATE_TIME) in the last hour. You can also filter by database name (TABLE_SCHEMA column).

查询示例：

SELECT CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS Table, UPDATE_TIME AS Updated
FROM INFORMATION_SCHEMA.TABLES
WHERE
    DATE_SUB(NOW(), INTERVAL 3 DAY) < UPDATE_TIME
    AND TABLE_SCHEMA != 'INFORMATION_SCHEMA'
    AND TABLE_TYPE = 'BASE TABLE';

这篇关于查询以查找在过去一小时内修改的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！