|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
July 13th, 2009, 12:50 AM
|
|||
|
|||
|
MySQL 5 - Removing Indexes
Hi,
Beside creating index you can also removing index by using DROP INDEX statement in MySQL. Interestingly, DROP INDEX statement is also mapped to ALTER TABLE statement. Here is the syntax: DROP INDEX index_name ON table_name --------- Thanks & regards Lokananth Live chat By miOOt
|
|
#2
July 13th, 2009, 08:10 AM
|
||||
|
||||
|
It is mapped to ALTER TABLE because DROP INDEX is changing the base table... Thus altering it.
__________________
life is a game.... Have fun ----------------------------- http://www.phpwomen.org strength in unity PHPCommunity IRC #phpc on freenode
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MySQL 5 - Removing Indexes |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
