SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName ,ENGINE as Engine | |
| 2 | FROM information_schema.TABLES | |
| 3 | WHERE ENGINE = 'MyISAM' -- or InnoDB | |
| 4 | AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema'); |
