The common method should be using:
LOAD DATA LOCAL INFILE 'myfile.csv' INTO TABLE table
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(field1, field2, field3, ....);I am recommending the next method that really worked:
Insert to the database line-by-line of CSV with this PHP file run by Command Prompt:
insert.php:
<?php
include 'config.php';
ini_set('max_execution_time', 0);
if (($handle = fopen("mycsvfile.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$c2=str_replace("'","\'", $data[2]);
$sql = "INSERT my_table (field1, field2)
values('val1','val2')";
mysql_query($sql,$link) or die("Insertion Failed:" . mysql_error());
}
fclose($handle);
}
?>
