Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Database > Mysql Tutorial > body text

What is the synonym statement for SHOW DATABASES? Through it we can see the list of MySQL databases?

WBOY

Release： 2023-08-24 11:21:05

forward

752 people have browsed it

SHOW DATABASES 的同义词语句是什么？通过它我们可以看到MySQL 数据库的列表？

We know that with the SHOW DATABASES statement, we can see the list of MySQL databases. Likewise, we can use SHOW SCHEMAS as a synonym for SHOW DATABASES to get the list of databases.

Example

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gaurav             |
| mysql              |
| performance_schema |
| query              |
| query1             |
| sys                |
| tutorials          |
+--------------------+
8 rows in set (0.07 sec)

mysql> SHOW SCHEMAS;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| gaurav             |
| mysql              |
| performance_schema |
| query              |
| query1             |
| sys                |
| tutorials          |
+--------------------+
8 rows in set (0.00 sec)

Copy after login

The above is the detailed content of What is the synonym statement for SHOW DATABASES? Through it we can see the list of MySQL databases?. For more information, please follow other related articles on the PHP Chinese website!

source：tutorialspoint.com

Previous article：How can we subtract values in MySQL table via LEFT JOIN? Next article：How do the MySQL FIELD() and ELT() functions complement each other?

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn