王新阳

查看所有表最后更新时间

SELECT 
	`TABLE_NAME`, `UPDATE_TIME` 
FROM 
	`information_schema`.`TABLES` 
WHERE 
	`information_schema`.`TABLES`.`TABLE_SCHEMA` = 'DB_NAME';

查看单个表最后更新时间

SELECT 
	`TABLE_NAME`, `UPDATE_TIME` 
FROM 
	`information_schema`.`TABLES` 
WHERE 
	`information_schema`.`TABLES`.`TABLE_SCHEMA` = 'DB_NAME' 
AND
	`information_schema`.`TABLES`.`TABLE_NAME` = 'TABLE_NAME';