Mysql .csv format data file

Mysql .csv format data file for yourself to back up, experts please ignore. The data on www.2cto.com is too big. You can use the database client software to directly import the plug-in, or directly execute SQL. 1. Specify the file path. 2. fields are separated by commas, and data rows are separated by \ r \ n (my files are separated by \ n ). 3. the string is enclosed by half-width double quotation marks. The double quotation marks of the string itself are represented by two double quotation marks. SQL code load data infile 'd: \ top-1m.csv 'into table' site 'fields terminated ', 'optionally enclosed by '"'escaped by'" 'Lines terminated by '\ n'; back up and export the data. SQL code select * from 'SITE' into outfile 'd: \ top-1m.csv 'fields terminated ', 'optionally enclosed by '"'escaped by'" 'Lines terminated by '\ n ';