SELECT TABLE_SCHEMA,TABLE_NAME,CREATE_TIME
FROM information_schema.`TABLES`
where TABLE_SCHEMA='defectdatabase'
AND DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(CREATE_TIME)
ORDER BY CREATE_Time DESC;
defectdatabase:数据库名
查询7天前的表
CREATE_TIME:字段,表的创建时间
-------------------------------------------------------------------------------------------------------------
SELECT TABLE_SCHEMA,TABLE_NAME,CREATE_TIME
FROM information_schema.`TABLES`
where TABLE_SCHEMA='defectdatabase';
AND PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( CREATE_TIME, '%Y%m' ) )>1
ORDER BY CREATE_Time DESC;
defectdatabase:数据库名
查询1个月前的表
CREATE_TIME:字段,表的创建时间