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