Return to Snippet

Revision: 65100
at October 24, 2013 19:25 by lyroge


Updated Code
/* Add Index */
ALTER TABLE [tablename] ADD INDEX IDX_IndexName(FieldName)

/* Drop Index */
Drop Index IDX_IndexName ON [tablename]

Revision: 65099
at October 24, 2013 19:19 by lyroge


Updated Code
/* Add Index */
ALTER TABLE [tablename] Add Index IDX_IndexName(FieldName)

/* Drop Index */
Drop Index IDX_IndexName on [tablename]

Revision: 65098
at October 24, 2013 19:19 by lyroge


Updated Code
/* Add Index */
ALTER TABLE [tablename] Add Index IDX_IndexName(FieldName)


Drop Index IDX_IndexName on [tablename]

Revision: 65097
at October 24, 2013 19:17 by lyroge


Updated Code
ALTER TABLE [tablename] Add Index IDX_IndexName(FieldName)


Drop Index IDX_IndexName on [tablename]

Revision: 65096
at October 24, 2013 19:17 by lyroge


Updated Code
ALTER TABLE [tablename] add index IDX_IndexName(FieldName)


drop index IDX_IndexName on [tablename]

Revision: 65095
at October 24, 2013 19:14 by lyroge


Initial Code
alert table [tablename] add index IDX_IndexName(FieldName)


drop index IDX_IndexName on [tablename]

Initial URL

                                

Initial Description
Drop and Add Index for Table of Mysql

Initial Title
Drop and Add Index for Table of Mysql

Initial Tags
mysql

Initial Language
MySQL