mysql建立索引语句

[iou3344]

mssql里面，下面这个建立非聚集索引语句在mysql里面的对应语句是什么呢？

create nonclustered index NonClu_IX_Contenta_aaa_bbb on Contenta (aaa desc,bbb desc)

[iou3344]

刚才百度是看到mysql里面不支持desc排序的索引，是这样的吗？

[ACMAIN_CHM]

create index NonClu_IX_Contenta_aaa_bbb on Contenta (aaa desc,bbb desc)

引用

CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) [index_option] ... index_col_name: col_name [(length)] [ASC | DESC] index_type: USING {BTREE | HASH | RTREE} index_option: KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name

[iou3344]

引用 2 楼 ACMAIN_CHM的回复:

create index NonClu_IX_Contenta_aaa_bbb on Contenta (aaa desc,bbb desc)

引用

CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) [index_option] ... index_col_name: col_name [(length)] [ASC | DESC] index_type: USING {BTREE | HASH | RTREE} index_option: KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name

这是mysql的建立索引的语句?你确定吗？