Database Reference
In-Depth Information
Here is an example taken from the Export page:
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—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" .
 
Search WWH ::




Custom Search