mysql导入csv文件

load data infile 'chpage.csv' into table c02_chpage fields terminated by  ','  lines terminated by '\r\n' (cID,link,sid,eid,step,siteid,focusid,linkname);

具体语法如下：

 LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]

INTO TABLE tbl_name
[FIELDS
[TERMINATED BY 't']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '/' ]]
[LINES TERMINATED BY 'n']
[IGNORE number LINES]
[(col_name,...)]