How to List all tables using InnoDB or MyISAM on Mysql Command | Web Hosting | Domain Registration | Wordpress Hosting | SSL Certificates

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';
SHARE