K
K
krlljs2014-05-14 20:36:14
MySQL
krlljs, 2014-05-14 20:36:14

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)

Please tell me how to get full information about the table? What is the correct mysql tutorial you can recommend? PS my goal is to wean myself from using phpmyadmin in favor of mysql-cli

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question