前提:csv文件字段结构和数据库一致,csv文件采用utf-8格式保存,windows操作系统
登录mysql
使用以下命令:
set names utf8;
LOAD DATA LOCAL INFILE c:/importfile.csv
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n';
登录mysql
使用以下命令:
set names utf8;
LOAD DATA LOCAL INFILE c:/importfile.csv
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n';