把文本文件导入mysql语法如下：

#show variables like 'secure%'; 查看路径

load data infile 'F:/UserData.csv' #地址
into table user                 #插入的表名
fields terminated by ","         #字段间以,号分隔
optionally enclosed by "'"         #字段用"号括起
escaped by '"'                     #字段中使用的转义符为"
lines terminated by '\r\n'         #行以\r\n结束
ignore 1 lines;