Exporting Structure and Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 120

• Fields escaped by : If the export generator finds the Fields enclosed by

character inside a field, the Fields escaped by character will be placed before
it in order to protect it. 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.