MySQL 索引操作總結

標籤：

本文主要總結了關於Mysql中索引的操作，主要涉及索引的查看，增加和刪除。

1. 查看索引

http://dev.mysql.com/doc/refman/5.7/en/show-index.html

SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr]

2. 插入索引

http://dev.mysql.com/doc/refman/5.7/en/create-index.html

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name    [index_type]    ON tbl_name (index_col_name,...)    [index_option]     [algorithm_option | lock_option] ...index_col_name:    col_name [(length)] [ASC | DESC]index_type:    USING {BTREE | HASH}index_option:    KEY_BLOCK_SIZE [=] value  | index_type  | WITH PARSER parser_name  | COMMENT ‘string‘algorithm_option:    ALGORITHM [=] {DEFAULT|INPLACE|COPY}lock_option:    LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}

3. 刪除索引

http://dev.mysql.com/doc/refman/5.7/en/drop-index.html

DROP INDEX index_name ON tbl_name    [algorithm_option | lock_option] ...algorithm_option:    ALGORITHM [=] {DEFAULT|INPLACE|COPY}lock_option:    LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}

 

MySQL 索引操作總結