Prev | Current Page 124 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

For example, "John \"The Great\" Smith".
Lines terminated by: This decides the character that ends each line. We
should use the proper line delimiter here depending on the operating system
on which we will manipulate the resulting export file. The default value of
this option comes from the $cfg['Export']['csv_terminated'] parameter
which contains 'AUTO' by default. The 'AUTO' value produces a value of \r\
n if the browser's OS is Windows and \n otherwise, but this might not be the
best choice if the export file is intended for a machine with a different OS.
Replace NULL by: This determines which string takes the place in the export
file of any NULL value found in a field.
Put fields names in the first row: This gets some information about the
meaning of each field. Some programs will use this information to name
the column.
Finally, we select the author table.
The result is:
"id","name","phone"
"1","John Smith","+01 445 789-1234"
"2","Maria Sunshine","+01 455 444-5683"
CSV for MS Excel
This export mode produces a CSV file intended for Microsoft Excel. We can select the
exact Microsoft Excel edition.
???
???
??? ???
Chapter 7
[ 127 ]
PDF
Since version 2.8.0, it's possible to create a PDF report of a table by exporting in
PDF. This feature works on only one table at a time, and we must click the Save as
file checkbox for normal operation.


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