Importing a CSV file into MySQL

[jonnym]

What's the best, most efficient method to import a csv file into a mysql database?

Do I load all the fields into an array and then loop and update sql statement on each row?

[maganv0x]

Try something like this. This is from a comma delimited CVS with 7 fields. Alter to your likings.

$fp = fopen ("data.csv","r"); 

while ($data = fgetcsv ($fp, 1000, ",")) { 

$var1=$data[0]; 
$var2=$data[1]; 
$var3=$data[2]; 
$var4=$data[3]; 
$var5=$data[4]; 
$var6=$data[5]; 
$var7=$data[6]; 


$query="INSERT INTO TABLENAME(field1,field2,field3,field4,field5,field6,field7)
VALUES ('$var1', '$var2', '$var3', '$var4', '$var5', '$var6', '$var7');"; 

$result = mysql_query($query) or die ("database error"); 


} 
fclose ($fp); 

?>

You can even use the LOAD DATA function to do it as well

LOAD DATA INFILE 'data.csv' INTO TABLE example FIELDS TERMINATED BY ',';

[dalecosp]

LOAD DATA INFILE REFERENCE.