（普通索引/主键索引）mysql表中创建索引，显示索引，删除索引

#创建表
CREATE TABLE tab11 (
    nid INT auto_increment NOT NULL PRIMARY KEY,
    NAME VARCHAR (32),
    email VARCHAR (32)
) ENGINE = INNODB CHARSET = utf8;

#显示表结构

desc tab11;
#创建表索引

CREATE INDEX ix_name ON tab11(name);
#显示表索引

show INDEX from tab11;
#删除表索引

drop INDEX ix_name ON tab11;