MySQL import and export CSV file _ MySQL

MySQL imports and exports CSV files bitsCN.com

MySQL provides a tool for importing and exporting databases. However, sometimes we only need to import and export data from a single table, such as importing and exporting CSV files. in this case, you can use the MySQL automatic command to import and export data.

The export syntax is as follows:

SELECT * FROM [TABLE]

Into outfile '[FILE]';

Or

SELECT * FROM [TABLE]

Into outfile '[FILE]'

Fields terminated ','

Optionally enclosed '"'

Lines terminated by '/N ';

Below is a specific example of export:

SELECT * FROM mytable

Into outfile '/tmp/mytable.csv'

Fields terminated ','

Optionally enclosed '"'

Lines terminated by '/N ';

The import syntax is as follows:

Load data infile '[FILE]'

Into table [TABLE];

Or

Load data infile '[FILE]'

Into table [TABLE]

Fields terminated ','

Optionally enclosed '"'

Lines terminated by '/N ';

Below is a specific import example:

Load data infile '/tmp/mytable.csv'

Into table mytable

Fields terminated ','

Optionally enclosed '"'

Lines terminated by '/N ';

From the column kongxx

BitsCN.com