导入时,系统会默认一个导入路径,如果导入路径不是默认路径,会报
The MySQL server is running with the --secure-file-priv option so it cannot...
的错误,可通过show variables like '%secure%';查看路径。
load data infile '/root/*****.csv' into table table_name FIELDS TERMINATED BY ','#字段间以,号分隔,默认为空格# OPTIONALLY ENCLOSED BY '"'#字段以"号括起,默认无# lines terminated by '\r\n' #行以\r\n结束,默认无# ignore 1 lines #跳过第一行# ('id','lenovoid','realname');#csv中数据以这个顺序插入表中#