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,...)]