Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 110

CSV
This format is understood by a lot of programs, and you may find it useful for
exchanging data. Note that it is a data-only format - there is no SQL structure here.

The available options are:

• Fields terminated by : We put a comma here, which means that a comma will

be placed after each field.
Fields enclosed by : We place an enclosing character here (like the quote) to
ensure that a field containing the terminating character (comma) is not taken
for two fields.
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. Here we choose \n for
a UNIX-style new line.
Replace NULL by : This determines which string takes the place in the export
file of any NULL value found in a field.

•

•

•

•