怎样删除索引？

mysql> show index from books;
+-------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| books |          0 | name             |            1 | name        | A         |           1 |     NULL | NULL   | YES  | BTREE      |         |               |
| books |          1 | books_index_name |            1 | name        | A         |           1 |     NULL | NULL   | YES  | BTREE      |         |               |
| books |          1 | books_index_name |            2 | author      | A         |           1 |     NULL | NULL   | YES  | BTREE      |         |               |
+-------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.00 sec)

mysql> drop index name on books;
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0

DROP INDEX 索引名 ON 表名；