show databases [like_or_where]
显示 mysql 中所有数据库的名称。实例:mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| mysql-test |
| performance_schema |
| sakila |
| sys |
| test |
| world |
+--------------------+
8 rows in set (0.00 sec)
也可以使用 like 或 where 对结果进行过滤。如下:mysql> show databases like '%mysql%';
+--------------------+
| Database (%mysql%) |
+--------------------+
| mysql |
| mysql-test |
+--------------------+
2 rows in set (0.00 sec)