Databases Reference
In-Depth Information
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.
TEXT
We will now explore how to use the
TEXT
field type and the relevant configuration
values to adjust for the best possible phpMyAdmin behavior.
First we add to the
topics
table a
TEXT
field called
description
:
Search WWH ::
Custom Search