过滤库中所有MyISAM的数据表

SELECT TABLE_SCHEMA,
       TABLE_NAME,
       TABLE_COLLATION,
       ENGINE,
       TABLE_ROWS
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA NOT IN ('INFORMATION_SCHEMA' ,
                           'SYS',
                           'MYSQL',
                           'PERFORMANCE_SCHEMA')
  AND TABLE_TYPE='BASE TABLE'
  AND ENGINE IN ('myisam')
  AND TABLE_SCHEMA = '库名'
ORDER BY TABLE_ROWS DESC ;

#INFORMATION_SCHEMA是元数据库
#tables表记录所有的表信息