导入.csv文件
2021-09-01 本文已影响0人
这货不是王马勺
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
