Shulou(Shulou.com)06/01 Report--

This article mainly introduces mysql query table information flow analysis, hope to give you some knowledge to supplement and update, if there are other problems to understand, you can continue to pay attention to my update article in the industry information.

SHOW COLUMNS FROM DATA TABLE: Displays attributes, attribute types, primary key information, NULL, default values and other information of the data table.

12345678910mysql> SHOW COLUMNS FROM runoob_tbl;+-----------------+--------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-----------------+--------------+------+-----+---------+-------+| runoob_id | int(11) | NO | PRI | NULL | || runoob_title | varchar(255) | YES | | NULL | || runoob_author | varchar(255) | YES | | NULL | || submission_date | date | YES | | NULL | |+-----------------+--------------+------+-----+---------+-------+4 rows in set (0.01 sec)

SHOW INDEX FROM DATA TABLE: Displays detailed index information for the data table, including PRIMARY KEY.

1234567mysql> SHOW INDEX FROM runoob_tbl;+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| runoob_tbl | 0 | PRIMARY | 1 | runoob_id | A | 2 | NULL | NULL | | BTREE | | |+------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+1 row in set (0.00 sec)

SHOW TABLE STATUS LIKE [FROM db_name] [LIKE 'pattern']\G: This command outputs MySQL database management system performance and statistics.

1234mysql> SHOW TABLE STATUS FROM RUNOOB; #Display information about all tables in the database RUNOOB mysql> SHOW TABLE STATUS from RUNOOB LIKE 'runoob %';#Information about tables whose names begin with runoob mysql> SHOW TABLE STATUS from RUNOOB LIKE 'runoob %'\G; #Add\G, query results are printed column by column

Read the above on mysql query table information flow analysis, I hope to give you some help in the actual application. Due to the limited space of this article, it is inevitable that there will be deficiencies and needs to be supplemented. If you need more professional answers, you can contact our 24-hour pre-sales service on the official website to help you answer your questions at any time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.