How can we see the MySQL temporary table in the table list?

As we all know, we can use the SHOW TABLES statement to view the list of tables in the database. But MySQL temporary tables are not stored in this list, or in other words, we cannot see the temporary tables with the help of SHOW TABLES statement. To illustrate this, we are using the following example -

Example

In this example, we are trying to get a temporary table named "SalesSummary" from the SHOW TABLES statement , as shown below -

mysql> SHOW TABLES LIKE '%Sales%';
Empty set (0.00 sec)

mysql> SHOW TABLES LIKE '%SalesSummary%';
Empty set (0.00 sec)

The above query shows that the result set is empty, which means that the temporary table "SalesSummary" is not in the table list of the database.

The above is the detailed content of How can we see the MySQL temporary table in the table list?. For more information, please follow other related articles on the PHP Chinese website!