Home >Database >Mysql Tutorial >mysql中如何查看和删除唯一索引_MySQL
mysql中如何查看和删除唯一索引_MySQL
- WBOYOriginal
- 2016-06-01 13:06:19972browse
mysql中如何查看和删除唯一索引。
查看唯一索引:
show index from mytable;//mytable 是表名
查询结果如下：
查询到唯一索引后，如何删除唯一索引呢，使用如下命令：
alter table mytable drop index mdl_tag_use_ix;//mdl_tag_use_ix是上表查出的索引名，key_name
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：数据库工具sysbench安装教程和性能测试例子_MySQLNext article：Linux mysql 常用命令_MySQL