SHOW DATABASES

SHOW SCHEMAS 是 SHOW DATABASES 语句的别名。

+--------------------+
| Database           |
+--------------------+
| INFORMATION_SCHEMA |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

Query OK, 0 rows affected (0.10 sec)

+--------------------+
| Database           |
| PERFORMANCE_SCHEMA |
| mynewdb            |
| mysql              |
| test               |
+--------------------+
5 rows in set (0.00 sec)

• DROP DATABASE