MYSQL數(shù)據(jù)庫(kù)創(chuàng)建索引目錄的方法和代碼

    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}
    -- 創(chuàng)建無索引的表格
    create table testNoPK (
    id int not null,
    name varchar(10)
    );
    -- 創(chuàng)建普通索引
    create index IDX_testNoPK_Name on testNoPK (name);