Databases Reference
In-Depth Information
The
'0'
here refers to the index number for
sort
, and the
'-r'
is a parameter for
sort
,
which makes the program sort in the reverse order.
Next, we edit the row for the topic "A hundred years of cinema (volume 1)", entering
some keywords in no particular order (as seen in the following screenshot) and
hitting
Go
in order to save the changes:
To test the effects of the external program, we browse our table and see the sorted
in-cell keywords:
Notice that the keywords are displayed in reverse sorted order.
Summary
In this chapter, we learnt how to improve the browsing experience by transforming
data using various methods. In particular, we saw how to display an overview
of thumbnail and full-size images from
.jpeg
and
.png
BLOB
columns, how to
generate links, format dates, display only parts of texts, and how to execute external
programs to reformat cell contents.
The next chapter will cover phpMyAdmin's support for the MySQL features that are
new in versions 5.0 and 5.1.
Search WWH ::
Custom Search