Mysql添加多个索引方法

  • Post author:
  • Post category: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`) ;



版权声明:本文为iteye_13003原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。