LOAD DATA INFILE

LOAD DATA INFILE "C:/Apache2.2/htdocs/handhouse/admin/upload/1.txt" INTO TABLE t_baseinfo  FIELDS TERMINATED BY ',' (houseNO,position,address,housetype,housearea,sale,unitprice,establishdegree,rightbelong);