MySQL 创建索引(Create Index)的方法和语法结构及例子

MySQL 创建索引(Create Index)的方法和语法结构及例子

CREATE INDEX Syntax文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

[index_type]文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

ON tbl_name (index_col_name,...)文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

[index_type]文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

index_col_name:文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

col_name [(length)] [ASC | DESC]文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/51793.html

index_type:

USING {BTREE | HASH | RTREE}