Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Editing Field Attributes


On the Structure sub-page, we can make further changes to our table. For this example, we have set $cfg['PropertiesIconic'] to 'both' to see the icons along with their text explanation:

This panel does not allow every possible change to fields. It specifically allows:

  • Changing one field structure, using the Change link on a specific field

  • Removing a field: Drop

  • Adding a field to an existing Primary key

  • Setting a non-unique Index or a Unique index on a field

  • Setting a Fulltext index (offered only if the field type allows it)

These are quick links that may be useful in some situations, but they do not replace the full index management panel, both of which are explained in this chapter.

We can also use the checkboxes to choose fields and, with the appropriate With selected icons, edit the fields or do a multiple field deletion with Drop. The Check All / Uncheck All option permits us to easily check or uncheck all boxes.