Count Number of Tables in a MySQL Database

 1mysql> select distinct(TABLE_SCHEMA) from information_schema.tables;
 2+--------------------+
 3| TABLE_SCHEMA       |
 4+--------------------+
 5| information_schema |
 6| drcongo            |
 7| mysql              |
 8| performance_schema |
 9| pseademo           |
10| pseairaq           |
11| sys                |
12+--------------------+
13 
14mysql> select count(*) from information_schema.tables where TABLE_SCHEMA='drcongo';
15+----------+
16| count(*) |
17+----------+
18|      333 |
19+----------+
201 row in set (0.00 sec)