索引的创建

创建索引，查看索引，删除索引

假设一张表t包含id，a，b三个字段，给里面插入1000条数据

CREATE TABLE `t` (
  `id` int(11) NOT NULL,
  `a` int(11) DEFAULT NULL,
  `b` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB;


//插入数据
delimiter ;;
create procedure idata()
begin
  declare i int;
  set i=1;
  while(i<=1000)do
    insert into t values(i, i, i);
    set i=i+1;
  end while;
end;;

创建索引
create index index_name on table_name (column_name)
给a字段创建索引

create index index_a on t (a)

创建联合索引
CREATE INDEX index_name ON table_name (column1，column2)
给a，b字段建立联合索引

CREATE INDEX index_ab ON t (a,b)

查看表中索引
show index from table_name;
查看表t的索引

show index from t;