Posted By

lyroge on 10/24/13


Tagged

mysql


Versions (?)

Drop and Add Index for Table of Mysql


 / Published in: MySQL
 

Drop and Add Index for Table of Mysql

  1. /* Add Index */
  2. ALTER TABLE [tablename] ADD INDEX IDX_IndexName(FieldName)
  3.  
  4. /* Drop Index */
  5. DROP INDEX IDX_IndexName ON [tablename]

Report this snippet  

You need to login to post a comment.