export

EXPORT

This function allows to import table content, search results or results of any SELECT or SHOW query into plain text files. Only SELECT privilege is required in order to use this function.

Currently there are two main export formats supported by this program:

Simple format (or CSV)
Advanced format.

To export a table select the desired table and hit EXPORT button:

Select a table and hit Export

Then select a format of the file to be created, select export options, select file options and click EXPORT. A message will be displayed saying whether or not the table was exported successfully.

The following file options are available:

Create new file
Overwrite existing file

CSV FORMAT

In CSV format, comma or semicolon delimited plain text files will be generated. Such files are compatible with popular third party applications such as MS EXCEL etc.
Two import options are available for CSV format:
- Comma separated values
- Semicolon separated values

ADVANCED FORMAT

Advanced format emulates SQL query SELECT INTO OUTFILE using the same export options.
A file of this format can be used then with SQL query LOAD DATA INFILE to import data into the table.
See MySQL online manual for details: http://www.mysql.com/doc/en/SELECT.html

Select format of exported file

Field options:

Fields terminated by: This is the column value separation character in the data file. Default value is TAB.
Fields enclosed by: The column values are enclosed within this character. If "Optionally" is checked only nonnumeric columns are enclosed. By default no values are enclosed.
Fields escaped by: This is the escape character for special characters. The default value is Backslash `\'.

The following characters are always escaped: Fields terminated by, Fields enclosed by, Fields escaped by.

The first character of Lines terminated by string is also escaped.

Line options:

Lines terminated by: All the rows will be terminated with this value. This value may be more than one character. The default value of Lines terminated by is newline character(s).

Previous

TOC

Next

[Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]