Prev | Current Page 125 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

We can add a title for this report, and it also
gets automatically paginated. In versions 2.8.0 to 2.8.2, this export format does not
support non-textual (BLOB) data as in the book table; if we try it in this table, it will
produce the wrong results.
Here we test it on the author table.
PDF is interesting because of its vectorial inherent nature: the results can be zoomed.
Let's have a look at the generated report, as seen from Acrobat Reader:
Microsoft Excel 2000
This export format directly produces an .xls file suitable for all software that
understands the Excel 2000 format. We can specify which string should replace any
NULL value. The Put field names in the first row option, when activated, generates
the table's column names as the first line of the spreadsheet. Again, the Save as file
checkbox should be checked. This produces a file where each table's column becomes
a spreadsheet column.
Exporting Structure and Data
[ 128 ]
Microsoft Word 2000
This export format directly produces a .doc file suitable for all software that
understands the Word 2000 format. We find options similar to those in the Microsoft
Excel 2000 export, and a few more. We can independently export the table's
Structure and Data.
Note that, for this format and the Excel format, we can choose many tables for one
export, but unpleasant results happen if one of these tables has non-textual data.


Pages:
113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137