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

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

CREATE INDEX Syntax很文博客-https://www.zhenjiekeji.com/51793.html

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

[index_type]很文博客-https://www.zhenjiekeji.com/51793.html

ON tbl_name (index_col_name,...)很文博客-https://www.zhenjiekeji.com/51793.html

[index_type]很文博客-https://www.zhenjiekeji.com/51793.html

index_col_name:很文博客-https://www.zhenjiekeji.com/51793.html

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

index_type:

USING {BTREE | HASH | RTREE}