mysql增加和删除索引的相关操作

ALTER TABLE xxxxx ADD INDEX `tid` (`tid`) USING BTREE;DROP INDEX uid ON xxxx;show index from xxxx