组合索引

CREATE TABLE tab15 (
    nid INT auto_increment NOT NULL PRIMARY KEY,
    NAME VARCHAR (32),
    email VARCHAR (32)
) ENGINE = INNODB CHARSET = utf8;

desc tab15;

CREATE INDEX ix_nid_name ON tab15(nid,name);