CREATE INDEX Syntax

CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name

[index_type]

ON tbl_name (index_col_name,...)

[index_type]

index_col_name:

col_name [(length)] [ASC | DESC]

index_type:

USING {BTREE | HASH | RTREE}

复制代码 代码如下:

-- 创建无索引的表格

create table testNoPK (

id int not null,

name varchar(10)

);

-- 创建普通索引

create index IDX_testNoPK_Name on testNoPK (name);