MySQL drop tables where engine is memory
drop * from db1 where engine = memory;

select table_name
from information_schema.tables
where table_schema = 'db1' and engine = 'memory';