1.local_infile服务器变量设置为ON。
SHOW VARIABLES LIKE '%local%';
SET GLOBAL local_infile=1
2.load data infile语句使用
LOAD DATA LOCAL INFILE 'C:\\\\Users\\\\lenovo\\\\Desktop\\\\aaa\\\\表名.dbf' INTO TABLE 表名 charset utf8 FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n';