mysql load

LOAD DATA local INFILE 'D:\\2.del' 
INTO TABLE tablenm
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(pri_key,trans_at) ;

注意事项：

1）路径能有中文名，否则报mysql load  not found (Errcode: 2 - No such file or directory)

2）FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'

这些东西，要写在表名之后，字段名之前。

否则是语法错误。