33.笔记 MySQL学习——删除索引
命令有两种可以是DROP INDEX或者ALTER TABLE
如果是DROP INDEX 需要给出删除索引的名字
例如DROP INDEX index_name ON tbl_name;
使用ALTER TABLE 命令如下:
ALTER TABLE tbl_name DROP INDEX index_name;
ALTER TABLE tbl_name DROP PRIMARY KEY;
可以使用SHOW INDEX来查询索引如下:
mysql> show index from mytbl;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name |Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null| Index_type | Comment | Index_comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| mytbl | 0 | PRIMARY | 1 | i | A | 0 | NULL | NULL | | BTREE | | |
| mytbl | 0 | j | 1 | j | A | 0 | NULL | NULL | | BTREE | | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)
当从表里删除列时,索引会隐式受到影响。如果删除了某个索引的所有列,MYSQL会删除整个索引。