导入.csv文件

load data infile '需要导入的文件全名' into table 将要导入的数据库表名 fields terminated by '列的分隔符' optionally enclosed by '"' escaped by '"' lines terminated by '回车换行符';

load data infile 'D:/Master.csv' into table cdr fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

show variables like 'secure%';

secure_file_priv = D:/

使用heidisql导入时，注意中文的话编码集设成gb2312