首页 > 代码库 > mysql表最后修改时间

mysql表最后修改时间

select TABLE_NAME,UPDATE_TIME from information_schema.TABLES where TABLE_SCHEMA=‘数据库名‘ order by UPDATE_TIME desc limit 1; 

select TABLE_NAME,UPDATE_TIME from information_schema.TABLES where TABLE_SCHEMA=‘数据库名‘ and information_schema.TABLES.TABLE_NAME = ‘表名‘; 

mysql表最后修改时间