php mysql批量导入大文本文件

要点：使用load data local infile 

$con = mysql_connect('localhost','root','123456');

mysql_select_db('12',$con); 
//$sql="load data local infile './11.txt' into table user FIELDS TERMINATED BY '----'(email,pwd1,name,credit,pwd2,tel,email2); ";
//$sql="load data local infile './10.csv'  into table home  FIELDS TERMINATED BY ',' IGNORE 1 LINES(Name,CardNo,Description,CtfTp,CtfId,Gender,Birthday,Address,Zip,Dirty,District1,District2,District3,District4,District5,District6,FirstNm,LastNm,Duty,Mobile,Tel,Fax,EMail,Nation,Taste,Education,Company,CTel,CAddress,CZip,Family,Version,LastId);";
$query=mysql_query($sql);
//$sql="select * from admin where name='$name' and password='$password'";
//$query=mysql_query($sql);