Drop inactive tables (MyISAM engine) which haven't been accessed for 2 months

drop_inactive_tables.sql

; Drop query
SET group_concat_max_len = 1024 * 1024 * 10;

SELECT CONCAT('DROP TABLE ',GROUP_CONCAT(CONCAT(table_schema,'.',table_name)),';') INTO @dropcmd FROM information_schema.tables
WHERE table_schema = 'test'
AND table_name LIKE '%temp\_data%'
AND DATE_ADD(update_time, INTERVAL +2 month) < CURDATE()
ORDER BY update_time DESC;

PREPARE str FROM @dropcmd; EXECUTE str; DEALLOCATE PREPARE str;

; Example Query
SELECT table_schema,
  table_name,
  update_time as LastAccessed
FROM information_schema.tables
WHERE table_schema = 'test'
AND table_name LIKE '%temp\_data%'
AND DATE_ADD(update_time, INTERVAL +2 month) < CURDATE()
ORDER BY update_time DESC;