EXPLAIN 跟selsect 查询语句
1、主键的删除和添加alter
alter table `so_search_attr_relation` drop PRIMARY key, add PRIMARY key (`id`);
添加普通索引
alter table `so_search_attr_relation` add index `inx_kid` (`kid`);
添加唯一索引
alter table `mk_test` add unique `NewIndex1` (`kid`, `status`);
添加全文索引
alter table `mk_test` add fulltext`NewIndex1` (`kid`, `status`);