MySQL count the number of tables in database

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'your-database-name';