如何將 CSV 檔案中的特定欄位匯入 MySQL？

Selective Column Import from CSV to MySQL Database via LOAD DATA INFILE

When working with large comma-separated value (CSV) files, it becomes necessary to selectively import specific columns into a MySQL database. The LOAD DATA INFILE command offers a convenient way to achieve this goal.

To selectively import chosen columns from a CSV file, use the following syntax:

LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE t1 
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'  
(@col1,@col2,@col3,@col4) set name=@col4,id=@col2 ;

Here's a breakdown:

• @col1,2,3,4 represent variables used to store the CSV file's columns (presuming there are four columns).
• name,id represent the table columns that will receive the imported data.

By following these steps, you can efficiently extract and import only the desired columns from a CSV file into your MySQL database.

以上是如何將 CSV 檔案中的特定欄位匯入 MySQL？的詳細內容。更多資訊請關注PHP中文網其他相關文章！