Prev | Current Page 100 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

Here, we specify how many new fields we want and where they will go.
The positions of the new fields in the table only matter from a developer's point of
view; we usually group the fields logically so that we can find them more easily in
the list of fields. The exact position of the fields will not play a role in the intended
results (output from the queries), because these results can be adjusted regardless
of the table structure. Usually, the most important fields (including the keys) are
located at the beginning of the table, but this is a matter of personal preference.
We choose to put the new field At End of Table, so we check the corresponding
radio button and click on Go:
Other possible choices would be At Beginning of Table and After (where we
would have to choose from the drop-down menu the field after which the new field
must go).
Changing Table Structures
[ 98 ]
We see the familiar panel for the new fields, repeated for the number of fields asked
for. We fill it in, and this time, we enter a default value, en. We then click on Save.
Vertical Mode
The previous panel appeared in vertical mode because the default for
$cfg['DefaultPropDisplay'] is 3, which means that for three columns or less,
the vertical mode is used and for more than three, horizontal mode would be
automatically selected. We can use here a number of our choosing.


Pages:
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112