您可以借助 INFORMATION_SCHEMA.TABLES 来实现此目的。使用带间隔的 date_sub() 。语法如下 –
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLESWHERE DATE_SUB(NOW(), INTERVAL -1HOUR) < ‘UPDATE_TIME’;
现在您可以检查上面的语法。这是查找过去一小时内修改的表的查询 –
mysql> select table_name from `INFORMATION_SCHEMA`.`TABLES`-> WHERE-> DATE_SUB(NOW(), INTERVAL 1 HOUR) < `UPDATE_TIME`;
输出
+---------------------+| TABLE_NAME |+---------------------+| innodb_table_stats || innodb_index_stats || employeeinformation |+---------------------+3 rows in set (0.37 sec)
以上查询仅选择表名。如果您想要表架构、表类型等信息，则需要使用以下查询。查询显示最近一小时内修改的表 –
图改改
在线修改图片文字
455 查看详情
mysql> SELECT *-> FROM `INFORMATION_SCHEMA`.`TABLES`-> WHERE-> DATE_SUB(NOW(), INTERVAL 1 HOUR) < `UPDATE_TIME`;
以下是显示最近一小时内修改的表信息的输出 –
+---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+---------------------------------------+---------------+| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT |+---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+---------------------------------------+---------------+| def | mysql | innodb_table_stats | BASE TABLE | InnoDB | 10 | Dynamic | 449 | 145 | 65536 | 0 | 0 | 4194304 | NULL | 2018-09-22 20:37:26 | 2018-12-24 15:13:41 | NULL | utf8_bin | NULL |row_format=DYNAMIC stats_persistent=0 | || def | mysql | innodb_index_stats | BASE TABLE | InnoDB | 10 | Dynamic | 1413 | 243 | 344064 | 0 | 0 | 4194304 | NULL | 2018-09-22 20:37:26 | 2018-12-24 15:13:41 | NULL | utf8_bin | NULL |row_format=DYNAMIC stats_persistent=0 | || def | test | employeeinformation | BASE TABLE | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 0 | NULL | 2018-12-24 15:12:04 | 2018-12-24 15:14:00 | NULL | utf8mb4_0900_ai_ci | NULL | ||+---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+---------------------------------------+---------------+3 rows in set (43.72 sec)
以上就是MySQL 查询查找最近一小时内修改的表？的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/226016.html
微信扫一扫 
支付宝扫一扫 
