InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Drop An Existing Index In Mysql? |
|
Answer» 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 : mysqi> DROP INDEX tip_subject ON tip; QUERY OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0If 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 : |
|