语句如下:

    1. create_index_stmt:
    2. CREATE [UNIQUE] INDEX index_name
    3. ON table_name (column_desc_list) [index_type]
    4. [index_option_list];
    5. | CREATE FULLTEXT INDEX index_name
    6. ON table_name (column_name_list) CTXCAT(column_name_list)
    7. [index_option_list];
    8. drop_index_stmt:
    9. DROP INDEX index_name ON table_name;
    10. column_desc_list:
    11. column_desc [, column_desc ...]
    12. column_desc:
    13. column_name [(length)] [ASC]
    14. index_type:
    15. USING BTREE
    16. index_option_list:
    17. index_option [index_option ...]
    18. index_option:
    19. [GLOBAL | LOCAL]
    20. | block_size
    21. | compression
    22. | STORING(column_name_list)
    23. | comment
    24. column_name_list:
    25. column_name [, column_name ...]