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

Popular posts from this blog

How to Delete WHM Mail Queue through SSH sent from a particular sender

how to change witribe wlan password? how to secure your witribe router

SOLVED: WHM/CPANEL Your server does not support the connection encryption type you have specified. Try changing the encryption method