mysql 创建索引和删除索引

SHOW INDEX FROM tm_show.tm_order;

SHOW CREATE TABLE tm_show.tm_order;

CREATE UNIQUE INDEX qianjinyan4ceshi ON tm_show.tm_order (orderNUmber);

DROP INDEX qianjinyan4ceshi ON tm_show.tm_order

  

原文地址:https://www.cnblogs.com/qianjinyan/p/12483875.html