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

mysql 创建索引和删除索引

标签：sql   pre   number   删除   创建索引   order   ber   drop   show