How to List all tables using InnoDB or MyISAM on Mysql Command

This query lists all InnoDB tables and their databases in MySQL:
SELECT table_name, table_schema 
FROM information_schema.tables 
WHERE engine = 'InnoDB';

Post a Comment

0 Comments