How MYSQL imports CSV Format data file Solution _mysql

For their own backup, the experts please ignore.
The data is too large, use the database client software to import the very card directly, or execute SQL directly.
1, specify the file path.
2, the fields are separated by commas, data rows are separated by \ r \ n (my files here are separated by \ n).
3. The string is surrounded by a half-angle double quotation mark, and the double quotation marks in the string itself are expressed in two double quotes.

SQL code

Copy Code code as follows:

Load data infile ' D:\\top-1m.csv '
into table ' site '
Fields terminated by ', ' optionally enclosed by ' "' escaped by '" '
Lines terminated by ' \ n ';

Incidentally, also back up an export bar.
SQL code

Copy Code code as follows:

SELECT * from ' site '
into outfile ' d:\\top-1m.csv '
Fields terminated by ', ' optionally enclosed by ' "' escaped by '" '
Lines terminated by ' \ n ';