MySQL itself has a CSV engine that allows you to import data from a CSV into a MySQL database, faster than a batch program written in PHP or Python.
specific implementation code examples:
Copy Code code as follows:
Load data infile '/tmp/file.csv ' into table _tablename (set character UTF8)
Fields terminated by ', '
Enclosed by ' "'
Lines terminated by ' \ r \ n ';
Some of the key words involved in this code are explained as follows:
Fields terminated by ': This is to indicate the field terminator in the CSV file, which is the delimiter between the data;
Enclosed by ': indicates an envelope character;
Lines terminated by ': line terminator
The CSV format is described in detail in the CSV document (RFC4180), with the following highlights:
(1) The fields are separated by a "," (comma) interval between rows of data using \ r \ n;
(2) 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.
Through the above explanation, detailed to the data import code should have a better understanding.
Similarly, the CSV data can be imported into the MySQL database, the data table in MySQL can also export the CSV file, the exported code example:
Copy Code code as follows:
SELECT * FROM tablename into outfile '/tmp/data.txt '
Fields terminated by ', '
Optionally enclosed by ' "'
Lines terminated by ' \ n ';
When you export data from a database to a file, and then import the data into the database, you must follow the format defined in the file that was exported.
