Drop and Add Index for Table of Mysql - MySQL Snipplr Social Repository

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