mysql索引表查询

iamwzh2003

mysql> show create table supervisor_list\G;
*************************** 1. row ***************************
       Table: supervisor_list
Create Table: CREATE TABLE `supervisor_list` (
  `super_id` int(10) unsigned NOT NULL auto_increment,
  `domain` varchar(128) NOT NULL,
  `supervisor` varchar(128) NOT NULL,
  `control_uid` varchar(128) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL default '3000-01-01 00:00:00',
  `create_time` datetime NOT NULL,
  PRIMARY KEY  (`super_id`),
  UNIQUE KEY `supervisor` (`supervisor`,`control_uid`),
  KEY `ind_supervisor_list` (`end_time`) 索引
) ENGINE=MyISAM AUTO_INCREMENT=35797 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

 

删除索引

 

drop index ind_supervisor_list on supervisor_list;

 

创建索引

 

create index ind_supervisor_list on supervisor_list(end_time);