Query all tables in MySQL

SELECT *
FROM   information_schema.tables
WHERE  table_type = 'BASE TABLE'