Counting mysql databases - Webmaster Forum - Web Design, Programming and SEO forums

09-22-2009, 09:09 PM

Stellarchase

Status: I'm new around here
Join date: Jun 2009
Location:
Expertise:
Software:

Posts: 15

iTrader: 0 / 0%

Stellarchase is on a distinguished road

Counting mysql databases

I understand how to count the amount of tables in a mysql database, but how about counting how many mysql databases exist (or at least the user has access to)

09-22-2009, 10:54 PM

Salathe

Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP

Posts: 3,820

iTrader: 25 / 100%

Salathe will become famous soon enough

You could use a query on the magic INFORMATION_SCHEMA database to get the number (see below), or just count the number of rows returned from SHOW DATABASES.

Example Query:

Code:

SELECT COUNT(SCHEMA_NAME) AS `Databases` FROM INFORMATION_SCHEMA.SCHEMATA;

Example Returns:

Code:

+-----------+
| Databases |
+-----------+
|         2 | 
+-----------+