找出哪些 Table 使用 InnoDB / MyISAM

JDP

[SQL] 純文本查看 複制代碼

SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb'; 
SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'myisam'; 

Reference:
MySQL 找出哪些 Table 使用 InnoDB / MyISAM
http://blog.longwin.com.tw/2009/ ... innodb-myisam-2009/