mysql 查看所有表的搜索引擎

SELECT table_name, table_type, engine FROM information_schema.tables 
WHERE table_schema = 'database_name' ORDER BY table_name DESC;