This article describes how to import csv data files in MySQL and provides detailed solutions. For more information, see
This article describes how to import csv data files in MySQL and provides detailed solutions. For more information, see
If you back up your data, ignore it.
If the data is too big, use the database client software to directly import the data into the memory, or execute SQL directly.
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
The Code is as follows:
Load data infile 'd: \ top-1m.csv'
Into table 'SITE'
Fields terminated by ', 'optionally enclosed by' "'escaped '"'
Lines terminated by '\ n ';
Back up and export the data.
SQL code
The Code is as follows:
Select * from 'SITE'
Into outfile 'd: \ top-1m.csv'
Fields terminated by ', 'optionally enclosed by' "'escaped '"'
Lines terminated by '\ n ';