Andrew McDonough

Please note: This page is imported from my wiki, which hasn't been updated in over 10 years. Some of the formatting was lost during the import. I'll try to get around to fixing it someday.

MySQL Indexing

Showing indicies

show index from <table_name>;

Adding indices

alter table <tablename> add index (<columnname>);

or if a text field. give a number of characters to index: alter table <tablename> add index (<columnname>(<no_chars>);


Andrew McDonough

Andrew McDonough is a consultant CTO and software developer, currently based between Berlin and London.

Follow Andrew on Twitter or Connect on LinkedIn