USING {BTREE|HASH} algorithm_option: ALGORITHM[=]{DEFAULT|INPLACE|COPY} lock_option: LOCK[=]{DEFAULT|NONE|SHARED|EXCLUSIVE} 一些存储引擎允许您在创建索引时指定索引类型。例如: CREATETABLElookup (idINT) ENGINE=MEMORY;CREATEINDEXid_indexONlookup (id) USING BTREE; B-TREE索引的特点 B-TREEB-TREE以...
USING {BTREE | HASH} algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} 一些存储引擎允许您在创建索引时指定索引类型。例如: CREATE TABLE lookup (id INT) ENGINE = MEMORY; CREATE INDEX id_index ON lookup (id) USING BT...
USING {BTREE | HASH} index_option: KEY_BLOCK_SIZE [=] value | index_type | WITH PARSER parser_name | COMMENT 'string' algorithm_option: ALGORITHM [=] {DEFAULT|INPLACE|COPY} lock_option: LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE} 索引类型:普通索引(什么都不加)、唯一索引(UNIQUE)、全文索引...