How can I see the description of a MySQL Temporary Tables?

MySQLMySQLi Database

We can check the description of a MySQL temporary table with the help of DESCRIBE statement, which is used to get the descriptions of other MySQL tables. With the help of the following example, we can illustrate it −

Example

mysql> DESCRIBE SalesSummary;
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| product_name     | varchar(50)      | NO   |     | NULL    |       |
| total_sales      | decimal(12,2)    | NO   |     | 0.00    |       |
| avg_unit_price   | decimal(7,2)     | NO   |     | 0.00    |       |
| total_units_sold | int(10) unsigned | NO   |     | 0       |       |
+------------------+------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

The above result set has the description of the temporary table ‘SalesSummary.

raja
Published on 22-Feb-2018 09:36:29
Advertisements