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

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)

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!