读书人

Mysql平添多个索引方法

发布时间: 2012-07-08 17:43:42 作者: rapoo

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`) ;

读书人网 >Mysql

热点推荐