LOAD DATA LOCAL INFILE ‘/home/user/www/upload/upload.csv’ INTO TABLE smstobesent FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\\n’ (name,contact_no)
$file_name=/home/user/www/upload/upload.csv
Load csv file into database using php script
$rs=mysql_query(“LOAD DATA LOCAL INFILE ‘$file_name’ INTO TABLE smstobesent FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\\n’ (name,contact_no)”) or die(“Error in Load File: “.mysql_error());
I had tried to run command from phpmyadmin using “LOAD DATA LOCAL INFILE ” but i was not able to load then i tried to load files using php script.
Thanks
Manoj