SHOW DATABASES

Description

Shows the list of databases that exist on the instance.

Syntax

1. > SHOW DATABASES [LIKE expr | WHERE expr]

Examples

1. > SHOW DATABASES;
2. +----------+
3. | Database |
4. +----------+
5. | default  |
6. | for_test |
7. | local    |
8. | ss       |
9. | ss1      |
10. | ss2      |
11. | ss3      |
12. | system   |
13. | test     |
14. +----------+
15. 9 rows in set (0.00 sec)