When connected to one MySQL database, how to view the table list of other MySQL databases?

With the SHOW TABLES From Database_name query, we can see the tables of another database. Here Database_name is the name of the database we are not currently using. Consider the following example where we run a query to get the list of tables in the database name "tutorial".

mysql> show tables from tutorial;
+--------------------+
| Tables_in_tutorial |
+--------------------+
| employee           |
| showzerofill       |
| student            |
+--------------------+
3 rows in set (0.00 sec)

The above is the detailed content of When connected to one MySQL database, how to view the table list of other MySQL databases?. For more information, please follow other related articles on the PHP Chinese website!