Monday, September 20, 2010

Mysql indexes Shortcuts

Mysql indexes

Inside a table:
INDEX(indexed_column)

Multiple Column Index
INDEX(indexed_column, indexed_column2)

Add Index to a table
ALTER TABLE table_name ADD INDEX(indexed_column)

Show Indexes:
SHOW INDEXES FROM table_name;

Remove Index
ALTER TABLE table_name DROP INDEX index_name;

No comments:

Post a Comment