语句如下:
create_index_stmt:
CREATE [UNIQUE] INDEX index_name
ON table_name (column_desc_list) [index_type]
[index_option_list];
| CREATE FULLTEXT INDEX index_name
ON table_name (column_name_list) CTXCAT(column_name_list)
[index_option_list];
drop_index_stmt:
DROP INDEX index_name ON table_name;
column_desc_list:
column_desc [, column_desc ...]
column_desc:
column_name [(length)] [ASC]
index_type:
USING BTREE
index_option_list:
index_option [index_option ...]
index_option:
[GLOBAL | LOCAL]
| block_size
| compression
| STORING(column_name_list)
| comment
column_name_list:
column_name [, column_name ...]