O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index management

phpMyAdmin has a number of index management options, which will be covered in this section.

Single-field indexes

We have already seen how the Structure panel offers a quick way to create an index on a single field, thanks to some quick links such as Primary, Index, and Unique. Under the field list (in the Details slider), there is a section of the interface available to manage indexes:

Single-field indexes

This section has links to edit or delete every index. Here, the Field part lists only one field per index, and we can see that the whole field participates in the index. This is because there is no size information after each field name, contrary to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required