How to count the number of tables in Mysql?

Question

I am trying to count the number of existing tables in a Mysql database.

I tried to do it the way below, but returned a syntax error:

SELECT COUNT(SHOW TABLES)

How can I do that?

Answer 1

Do so:

USE databasename; SHOW TABLES; SELECT FOUND_ROWS();

I put in the Github for future reference.

Source.