Import CSV Files using php and mysql

  To import csv files into the mysql table,for this removing the header of the csv files and then run the below script.It will be insert into our mysql table.

//Import csv files into mysql table

LOAD DATA LOCAL INFILE 'd:\\Site.csv' INTO TABLE `siteurl` 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\r\n';

//ends

Character Escape Sequence

\0 An ASCII NUL (0x00) character

\b A backspace character

\n A newline (linefeed) character

\r A carriage return character

\t A tab character

\Z ASCII 26 (Control+Z)

\N NULL

Note : Your File must be a Csv file.Then only it will be working.
  Csv File Name as Site.csv
  Table Name as siteurl

Csv Files import in MySql, Csv Files import in php, Import CSV Files into MySQL table