MySQL 为表添加索引

-- 直接创建索引

CREATE INDEX index_name ON table(column(length))

-- 修改表结构的方式添加索引

ALTER TABLE table_name ADD INDEX index_name ON (column(length))

-- 创建表的时候同时创建索引

CREATE TABLE `table` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`title` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`time` int(10) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX index_name (title(length))
)

-- 删除索引

DROP INDEX index_name ON table