The Designer manipulates all the tables of a database,
whereas the Edit PDF panel offers us a choice of tables, so that we can
represent a subset of the relations (in the case there are many tables).
Summary
In this chapter, we covered the documentation features offered by phpMyAdmin??”
the print view for a database or a table, and the data dictionary for a complete column
list. We also covered PDF relational schemas. In particular, we saw how to create and
modify a PDF schema page, and how to use the visual editor (scratchboard).
MIME-Based
Transformations
In this chapter, we cover a powerful phpMyAdmin feature: its ability to transform a
column's contents according to specific rules, called the transformations. This chapter
describes how we can transform the contents that we see in the Browse mode for a
table. Normally, the exact contents of each row are displayed, except that:
TEXT and CHARACTER fields might be truncated, according to
$cfg['LimitChars'], and whether we have clicked on the Full Text icon.
BLOB fields might be replaced by a message like [BLOB - 1.5 KB].
We will use the term cell to indicate a specific column of a specific row. The cell
containing the cover photograph for the 'Future souvenirs' book (a BLOB column) is
currently displayed as cryptic data like ??°PNG\r\n\Z\n\0\0\0\rIHDR\0, or as a
message stating the BLOB field's size.
Pages:
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220