方式1:
create index indexName on tableName(fieldName);
方式2:建表时指定索引
create table t_301(
tid int,
tname varchar(20),
gender varchar(1),
index [indexName] (fieldName)
);
方式3:
alter table tableName add unique index indexName (fieldName);