新增索引

  1. alter table `xcxmall_card_batch_card_secret` add unique(`card_key_num`);

查看索引

  1. show index from xcxmall_card_batch_card_secret;

删除索引

  1. DROP index 索引名 on 表名;