SELECT
`TABLE_NAME`, `UPDATE_TIME`
FROM
`information_schema`.`TABLES`
WHERE
`information_schema`.`TABLES`.`TABLE_SCHEMA` = 'xx_db_name'
AND
`information_schema`.`TABLES`.`TABLE_NAME` = 'xx_table_name'
#说明:
#1、xx_db_name:数据库名称
#2、xx_table_name:表名称
执行结果:
TABLE_NAME | UPDATE_TIME |
xx_db_name | 2022-02-23 18:30:00 |