1. 使用MySQL的LOAD DATA INFILE語(yǔ)句：
LOAD DATA INFILE 'data.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
2. 使用PHP的MySQLi擴(kuò)展：
$file = fopen('data.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . implode("','", $line) . "')";
mysqli_query($conn, $sql);
}
fclose($file);
