找出哪些 Table 使用 InnoDB / MyISAM

JDP

[mw_shl_code=sql,true]SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';
SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'myisam'; [/mw_shl_code]
Reference:
MySQL 找出哪些 Table 使用 InnoDB / MyISAM
http://blog.longwin.com.tw/2009/ ... innodb-myisam-2009/