日期:2014-05-16  浏览次数:20700 次

Mysql添加多个索引方法
ALTER TABLE `tbl_feeds`
ADD INDEX `IX_Feeds_username` (`username`) ,
ADD INDEX `IX_Feeds_userid` (`userid`) ,
ADD INDEX `IX_Feeds_content` (`content`) ,
ADD INDEX `IX_Feeds_content_md5` (`content_md5`) ,
ADD INDEX `IX_Feeds_reposts_num` (`reposts_num`) ,
ADD INDEX `IX_Feeds_comments_num` (`comments_num`) ,
ADD INDEX `IX_Feeds_website` (`website`) ,
ADD INDEX `IX_Feeds_app` (`app`) ,
ADD INDEX `IX_Feeds_is_original` (`is_original`) ,
ADD INDEX `IX_Feeds_original_content` (`original_content`) ,
ADD INDEX `IX_Feeds_original_content_md5` (`original_content_md5`) ,
ADD INDEX `IX_Feeds_original_username` (`original_username`) ,
ADD INDEX `IX_Feeds_score` (`score`) ,
ADD INDEX `IX_Feeds_weight` (`weight`) ;