Script need to insert data from 'new.csv' file to direct mysql database

[rudraraj das]

Hi friends,

I need your kind help. Actually I need the script which convert the whole data saved in .csv (coma separeted) extension to the mysql table.

the script looks like be:

$query="LOAD DATA LOCAL INFILE ******* REPLACE INTO TABLE `c1`
FIELDS TERMINATED BY ','
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'";


I lost the script marked as ****

Waiting for your reply.


Rudraraj