Collections:
Drop an Existing Index in MySQL
How To Drop an Existing Index in MySQL?
✍: FYIcenter.com
If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script:
mysql> DROP INDEX tip_subject ON tip; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW INDEX FROM TIP; +------------+-------------+--------------+-------------+... | Non_unique | Key_name | Seq_in_index | Column_name |... +------------+-------------+--------------+-------------+... | 0 | PRIMARY | 1 | id |... +------------+-------------+--------------+-------------+... 1 row in set (0.00 sec)
⇐ Show All Indexes of a given Table in MySQL
2018-02-14, 1463🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...