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

  

posted @ 2020-03-13 00:11  巴黎爱工作  阅读(149)  评论(0编辑  收藏  举报