MySQLshow：數(shù)據(jù)庫對象查看工具，用來快速查找存在哪些數(shù)據(jù)庫、數(shù)據(jù)庫中的表、表中的列或索引。

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對這個行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價值的長期合作伙伴，公司提供的服務(wù)項目有：域名注冊、網(wǎng)站空間、營銷軟件、網(wǎng)站建設(shè)、孝義網(wǎng)站維護、網(wǎng)站推廣。

選項：--count    顯示數(shù)據(jù)庫和表的統(tǒng)計信息

      -k         顯示指定的表中的索引

      -i         顯示表的狀態(tài)信息

不帶任何參數(shù)顯示所有數(shù)據(jù)庫

[root@www mysql-5.6.30]# mysqlshow

+--------------------+

|     Databases      |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

不指定數(shù)據(jù)庫，顯示數(shù)據(jù)庫和表的統(tǒng)計信息

[root@www mysql-5.6.30]# mysqlshow --count

+--------------------+--------+--------------+

|     Databases      | Tables |  Total Rows  |

+--------------------+--------+--------------+

| information_schema |     59 |        13157 |

| mysql              |     28 |         2474 |

| performance_schema |     52 |        16615 |

| test               |      2 |           24 |

+--------------------+--------+--------------+

4 rows in set.

指定數(shù)據(jù)庫，顯示統(tǒng)計信息

[root@www mysql-5.6.30]# mysqlshow -uroot test --count

Database: test

+----------+----------+------------+

|  Tables  | Columns  | Total Rows |

+----------+----------+------------+

| backt118 |        4 |         12 |

| t118     |        4 |         12 |

+----------+----------+------------+

2 rows in set.

指定數(shù)據(jù)庫和表，顯示統(tǒng)計信息

[root@www mysql-5.6.30]# mysqlshow -uroot test t118 --count

Database: test  Table: t118  Rows: 12

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

| Field   | Type     | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

| name    | char(10) | utf8_general_ci | YES  | MUL |         |       | select,insert,update,references |         |

| age     | int(3)   |                 | YES  |     |         |       | select,insert,update,references |         |

| chushen | date     |                 | YES  |     |         |       | select,insert,update,references |         |

| shengao | int(3)   |                 | YES  |     |         |       | select,insert,update,references |         |

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

顯示指定表所有的索引，前部分是表的結(jié)構(gòu)，后部分是表的索引信息

[root@www mysql-5.6.30]# mysqlshow -uroot test t118 -k

Database: test  Table: t118

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

| Field   | Type     | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

| name    | char(10) | utf8_general_ci | YES  | MUL |         |       | select,insert,update,references |         |

| age     | int(3)   |                 | YES  |     |         |       | select,insert,update,references |         |

| chushen | date     |                 | YES  |     |         |       | select,insert,update,references |         |

| shengao | int(3)   |                 | YES  |     |         |       | select,insert,update,references |         |

+---------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+

+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| t118  | 1          | index_name | 1            | name        | A         | 12          |          |        | YES  | BTREE      |         |               |

| t118  | 1          | index_ccc  | 1            | name        | A         | 12          |          |        | YES  | BTREE      |         |               |

+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

顯示表的狀態(tài)信息

[root@www mysql-5.6.30]# mysqlshow -i -uroot test t118

Database: test  Wildcard: t118

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment |

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+

| t118 | InnoDB | 10      | Compact    | 12   | 1365           | 16384       | 0               | 0            | 0         |                | 2017-04-29 22:33:47 |             |            | utf8_general_ci |          |                |         |

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+

網(wǎng)站題目：MySQL之?dāng)?shù)據(jù)庫對象查看工具mysqlshow
文章轉(zhuǎn)載：http://aaarwkj.com/article48/iipohp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供虛擬主機、品牌網(wǎng)站設(shè)計、商城網(wǎng)站、自適應(yīng)網(wǎng)站、用戶體驗、手機網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)