如何在MySQL中增加和删除索引？

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