Answer the question
In order to leave comments, you need to log in
How to get information about used table engine from mysql-cli?
I looked through a couple of mysql tutorials on the Internet, but did not find information on how to get information through the mysql command line client: about the table encoding, about its engine. In the books I found, in the same sequence, the authors give such commands as: show , use , select , and describe . The describe command from the category of commands that talks about the table, but is silent about the installed encoding and table engine:
mysql> describe time_zone;
+------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| Time_zone_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| Use_leap_seconds | enum('Y','N') | NO | | N | |
+------------------+------------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question