How Can I Import a CSV File into MySQL Using the LOAD DATA INFILE Command?

Importing CSV Data into MySQL Tables

Importing CSV data into a MySQL table can be achieved without the use of a GUI by utilizing the LOAD DATA syntax.

Syntax with First Row as Column Names:

To establish the first row of data as column names, execute the following code:

LOAD DATA LOCAL INFILE 'uniq.csv'
INTO TABLE tblUniq
FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(uniqName, uniqCity, uniqComments)

This assumes:

• The CSV file is named 'uniq.csv'.
• The columns are separated by commas (,).
• Quoted values are enclosed in double quotation marks (").
• Lines are terminated by newlines (n).
• The first row contains the column names which will be ignored.

Explanation:

• LOAD DATA initializes the data loading process.
• LOCAL INFILE specifies that the data is imported from a local file.
• IGNORE 1 LINES skips the header row (first line).
• FIELDS defines the column names and their delimiters.
• INTO specifies the target table.
• LINES specifies the line terminator.

The above is the detailed content of How Can I Import a CSV File into MySQL Using the LOAD DATA INFILE Command?. For more information, please follow other related articles on the PHP Chinese website!