在MySQL 里面导入CSV数据。
LOAD DATA INFILE "D:/hexway/code/lyf/db/gbk/login.csv"
REPLACE INTO TABLE login
CHARACTER SET gbk
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\r\n"
ignore 1 lines;
首先,打开命令行工具,引用数据库,然后执行如上代码,则可以把CSV数据导入到数据表中。
REPLACE INTO TABLE login
将数据插入到login表中。
CHARACTER SET gbk
设置字符编码格式。
FIELDS TERMINATED BY ","
CSV中字段分隔方式。
OPTIONALLY ENCLOSED BY '"'
字段是由双引号包括在其中。
LINES TERMINATED BY "\r\n"
每一行数据是用/r/n换行。
ignore 1 lines;
忽略第一行数据,第一行数据可能是表头。