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)