1.mysql -u root -p 输入密码
2.导入文件csv文件
load data local infile 'E:\\tmp\\prod.csv' into table aa fields terminated by ',' lines terminated by '\r\n';
注意替换文件路径
这里还可以导入txt文件
load data local infile 'C:\\Users\\70201\\Desktop\\asd.txt' into table a fields terminated by '$' lines terminated by '\r\n';