MySQL Index Operations Summary

This paper summarizes the operation of index in MySQL, mainly involves the view, increment and deletion of index.

1. View Index

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

SHOW {INDEX| | KEYS} {from| inch  [{from | in} db_name[WHERE expr]

2. Inserting an index

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

CREATE [unique| Fulltext| SPATIAL] INDEXindex_name[Index_type]     ontbl_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|  withPARSER Parser_name|COMMENT'string'Algorithm_option:algorithm[=]{DEFAULT|INPLACE|Copy}lock_option:lock[=]{DEFAULT|NONE|SHARED|EXCLUSIVE}

3. Deleting an index

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

DROP INDEXIndex_name onTbl_name[algorithm_option | lock_option]. .. algorithm_option:algorithm[=]{DEFAULT|INPLACE|Copy}lock_option:lock[=]{DEFAULT|NONE|SHARED|EXCLUSIVE}

MySQL Index Operations Summary